SQL

Create or replace table sql

CREATE OR REPLACE TABLE INVENTORY 
      (PART_NUMBER FOR PARTNO        SMALLINT NOT NULL,
       DESCRIPTION FOR DESCR         VARGRAPHIC(500) CCSID 1200,
       QUANTITY_ON_HAND FOR QONHAND  INT,
       LAST_MODIFIED FOR MODIFIED    TIMESTAMP
            NOT NULL GENERATED ALWAYS FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP,
       PRIMARY KEY(PARTNO))

sql "replace into table"

REPLACE INTO table
SET column1 = value1,
    column2 = value2;
Code language: SQL (Structured Query Language) (sql)