Tables

To create the Orders table, run this code:

CREATE TABLE IONTEST/ORDERS (ORDERNUM CHAR ( 20) NOT NULL,     
ORDERSTAT CHAR ( 20), ORDERTSTMP TIMESTAMP , CUSTOMER CHAR (20 
), LASTMOD TIMESTAMP NOT NULL WITH DEFAULT) RCDFMT ROrders

To create the Orderlines table, run this code:

CREATE TABLE IONTEST/ORDERLINE (ORDERNUM CHAR (20 ) NOT NULL,     
LINENUM INT NOT NULL, ITEM CHAR (20 ), QUANTITY INT , PRICE DEC   
(18 , 2)) RCDFMT ROrderline

To create the ProcOrd table, run this code:

CREATE TABLE IONTEST/ProcOrd (ORDERNUM CHAR (20 ) NOT       
NULL, PROCESSst CHAR (20 )) RCDFMT RProcOrd

To create the Orders_PUT table, run this code:

CREATE TABLE IONTEST.ORDERS_PUT (
                ORDERNUM CHAR(20) CCSID 37 NOT NULL ,
                ORDERSTAT CHAR(20) CCSID 37 DEFAULT NULL ,
                ORDERTSTMP TIMESTAMP DEFAULT NULL ,
                CUSTOMER CHAR(20) CCSID 37 DEFAULT NULL ,
                LASTMOD TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP )  
                RCDFMT RORDERS