Data Build Manual

Where to Go Next
Running the Sample Programs
099331 Tandem Computers Incorporated 5-21
An example of such a file is TBLSRC, which is provided with the samples. The
following is the file TBLSRC:
VOLUME $CONVERT.SQLCAT;; <-- Location of Catalog
DROP TABLE =DEMO01;
DROP TABLE =DEMO02;
DROP TABLE =DEMO03;
DROP CATALOG =CAT;
CREATE CATALOG =CAT SECURE "NNNN";
CREATE TABLE =DEMO01 <-- Table Description
(DEM1_STATE CHAR (2) NOT NULL
,DEM1_ZIPCODE CHAR (6) NOT NULL
,DEM1_PHONE NUMERIC (10,0) NOT NULL
,DEM1_NAME CHAR (25) NOT NULL
,DEM1_ADDRESS CHAR (25) NOT NULL
,DEM1_CITY CHAR (18) NOT NULL
,DEM1_CODE CHAR (14) NOT NULL
)
ORGANIZATION KEY SEQUENCED
CATALOG =CAT
EXTENT (20,64)
MAXEXTENTS 50
BUFFERED
NO AUDIT
;
CREATE TABLE =DEMO02
(DEM2_IDNUMBER SMALLINT NOT NULL
,DEM2_DESCR CHAR (9) NOT NULL
,DEM2_SUBNUMBER SMALLINT NOT NULL
,DEM2_CODE1 CHAR (1) NOT NULL
,DEM2_CLASS CHAR (3) NOT NULL
,DEM2_PRICE INTEGER DEFAULT SYSTEM NOT NULL
,DEM2_COST1 INTEGER NOT NULL
,DEM2_CARRIER CHAR (9) DEFAULT SYSTEM NOT NULL
,DEM2_COST2 INTEGER DEFAULT SYSTEM NOT NULL
,DEM2_VENDOR CHAR (5) DEFAULT SYSTEM NOT NULL
,DEM2_DATE1 DATE NOT NULL
,DEM2_DATE2 DATE
,DEM2_DATE3 DATE DEFAULT SYSTEM NOT NULL
,DEM2_TIME TIME DEFAULT SYSTEM NOT NULL
)
ORGANIZATION KEY SEQUENCED
CATALOG =CAT
CLUSTERING KEY (DEM2_SUBNUMBER,DEM2_IDNUMBER,DEM2_CLASS)
EXTENT (20,64)
MAXEXTENTS 50
BUFFERED
NO AUDIT
;
CREATE TABLE =DEMO03
(DEM3_DATE DATE DEFAULT SYSTEM NOT NULL
,DEM3_TIME TIME DEFAULT SYSTEM NOT NULL