ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 631
Sample DBEnvironment
CREATABS Command File
CREATABS Command File
/* The following commands create the Purchasing Department's DBEFileSet
with two DBEFiles. */
CREATE DBEFILESET PurchFS;
CREATE DBEFILE PurchDataF1
WITH PAGES = 50, NAME = 'PurchDF1',
TYPE = TABLE;
CREATE DBEFILE PurchIndxF1
WITH PAGES = 50, NAME = 'PurchXF1',
TYPE = INDEX;
ADD DBEFILE PurchDataF1
TO DBEFILESET PurchFS;
ADD DBEFILE PurchIndxF1
TO DBEFILESET PurchFS;
/* The following commands create the Warehouse Department's DBEFileSet
with two DBEFiles. */
CREATE DBEFILESET WarehFS;
CREATE DBEFILE WarehDataF1
WITH PAGES = 50, NAME = 'WarehDF1',
TYPE = TABLE;
CREATE DBEFILE WarehIndxF1
WITH PAGES = 50, NAME = 'WarehXF1',
TYPE = INDEX;
ADD DBEFILE WarehDataF1
TO DBEFILESET WarehFS;
ADD DBEFILE WarehIndxF1
TO DBEFILESET WarehFS;
/* The following commands create the Receiving Department's DBEFileSet
with two DBEFiles. */
CREATE DBEFILESET OrderFS;
CREATE DBEFILE OrderDataF1
WITH PAGES = 50, NAME = 'OrderDF1',
TYPE = TABLE;
CREATE DBEFILE OrderIndxF1
WITH PAGES = 50, NAME = 'OrderXF1',
TYPE = INDEX;
ADD DBEFILE OrderDataF1
TO DBEFILESET OrderFS;
ADD DBEFILE OrderIndxF1
TO DBEFILESET OrderFS;