Data Build Manual

Where to Go Next
Running the Sample Programs
5–22 099331 Tandem Computers Incorporated
,DEM3_NUMBER SMALLINT NOT NULL
,DEM3_DESCR CHAR (9) NOT NULL
,DEM3_TYPE SMALLINT NOT NULL
,DEM3_VENDORID INTEGER DEFAULT SYSTEM NOT NULL
,DEM3_WHLSLRID INTEGER NOT NULL
,DEM3_PARTNO INTEGER NOT NULL
,DEM3_PRICE NUMERIC (10,2) DEFAULT SYSTEM NOT NULL
,DEM3_CODE CHAR (2) NOT NULL
,DEM3_COST INTEGER DEFAULT SYSTEM NOT NULL
)
ORGANIZATION ENTRY SEQUENCED
CATALOG =CAT
EXTENT (20,64)
MAXEXTENTS 50
BUFFERED
NO AUDIT
;
CREATE INDEX DEM02I01
ON =DEMO02
(DEM2_SUBNUMBER ASC
,DEM2_DESCR ASC
,DEM2_CLASS ASC
)
EXTENT (20,10)
CATALOG =CAT
;
CREATE INDEX DEM02I02
ON =DEMO02
(DEM2_COST1 ASC
,DEM2_DATE3 ASC
)
EXTENT (20,10)
CATALOG =CAT
;
CREATE INDEX DEM03I01
ON =DEMO03
(DEM3_DESCR ASC
,DEM3_DATE ASC
)
EXTENT (20,10)
CATALOG =CATµ
;
To create these tables, you would enter:
SQLCI /IN tblsrc , OUT $ S.#tblsrc /
You would then check the spooler (location #TBLSRC in this case) for any errors or
warnings.
After the NonStop SQL table has been successfully created, you would enter a SQLCI
INVOKE for each table to create a file that, after modification, will be the record
descriptions file. The most logical time to do the above is after running the Project
utility and before starting Data Build.