CODE EXAMPLE FOR 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))