CREATE OR REPLACE TABLE TMPTST2 (                                              
 PO         INTEGER     GENERATED BY DEFAULT AS IDENTITY (START WITH 1,        
                        INCREMENT BY 1, ORDER, CYCLE, MINVALUE 1, NO MAXVALUE, 
                        NO CACHE) NOT HIDDEN,                                  
 VENDOR     INTEGER          NOT NULL DEFAULT 0 ,                              
 STATUS     CHAR(1) CCSID 37 NOT NULL DEFAULT '' ,                             
 CHG_OPER   CHAR(1) CCSID 37 NOT NULL                                          
              GENERATED ALWAYS AS (DATA CHANGE OPERATION),                     
 SYS_START  TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW BEGIN,              
 SYS_END    TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS ROW END,                
 TS_ID      TIMESTAMP(12) NOT NULL GENERATED ALWAYS AS TRANSACTION START ID,   
 PERIOD     SYSTEM_TIME (SYS_START, SYS_END),                                  
 NOTE       VARCHAR(100) ALLOCATE(50) NOT NULL DEFAULT ' ',                    
 AUDIT_USR  VARCHAR(128) CCSID 37 NOT NULL GENERATED ALWAYS AS (SESSION_USER), 
 CLIENT_USR VARCHAR(255) CCSID 37 NOT NULL                                     
              GENERATED ALWAYS AS (CURRENT CLIENT_USERID),                     
 CLIENT_APP VARCHAR(255) CCSID 37 NOT NULL                                     
              GENERATED ALWAYS AS (CURRENT CLIENT_APPLNAME),                   
 CLIENT_PGM VARCHAR(255) CCSID 37 NOT NULL                                     
               GENERATED ALWAYS AS (CURRENT CLIENT_PROGRAMID)   
 );                                                             
                                                                
                                                                               
ALTER TABLE TMPTST2                                                            
 ADD CONSTRAINT TMPTST2P1                                                      
 PRIMARY KEY( PO );                                                            
                                                                               
LABEL ON TABLE TMPTST2                                                         
 IS 'Temporal Testing 2';                                                      
                                                                               
LABEL ON COLUMN TMPTST2 (                                                      
 PO         IS 'Purchase            Order               Unique Id           ', 
 VENDOR     IS 'Vendor              Number                                  ', 
 STATUS     IS 'Status                                                      ', 
 CHG_OPER   IS 'Change              Operation                               ', 
 SYS_START  IS 'Time When           Data in Row         Becomes Current     ', 
 SYS_END    IS 'Time When           Data in Row         No Longer Current   ', 
 TS_ID      IS 'Time of First       Data Change         in Transaction      ', 
 NOTE       IS 'Note                                                        ', 
 AUDIT_USR  IS 'Audit               User                                    ', 
  CLIENT_USR IS 'Client              User                                    ',
  CLIENT_APP IS 'Client Application  Name For Current    Connection          ',
  CLIENT_PGM IS 'Client Program      Id For Current      Connection          ' 
 );                                                                            
                                                                               
 LABEL ON COLUMN TMPTST2 (                                                     
  PO         TEXT IS 'Purchase Order Number         ',                         
  VENDOR     TEXT IS 'Vendor Number                 ',                         
  STATUS     TEXT IS 'Status                        ',                         
  CHG_OPER   TEXT IS 'Change Operation              ',                         
  SYS_START  TEXT IS 'Time Data Becomes Current     ',                         
  SYS_END    TEXT IS 'Time Data No Longer Current   ',                         
  TS_ID      TEXT IS 'Time of First Data Change     ',                         
  NOTE       TEXT IS 'Note                          ',                         
  AUDIT_USR  TEXT IS 'Audit User                    ',                         
  CLIENT_USR TEXT IS 'Client User                   ',                         
  CLIENT_APP TEXT IS 'Client Application Name       ',                         
  CLIENT_PGM TEXT IS 'Client Program Id             '                          
);