ALLBASE/SQL Reference Manual (36216-90216)

Appendix C 629
Sample DBEnvironment
Listings of ISQL Command Files
Listings of ISQL Command Files
Both SQLSetup and setup use a group of ISQL command files to create and load local
copies of PartsDBE. These files, located in /usr/lib/allbase/hpsql/sampledb, are as follows:
• STARTDBE, an ISQL command file containing the START DBE command.
• CREATABS, an ISQL command file containing SQL commands. for creating
DBEFileSets, DBEFiles, tables, and views
• LOADTABS, an ISQL command file containing ISQL and SQL commands for loading
the two tables in the ManufDB database, the six tables in the PurchDB database, and
the three tables in the RecDB database in the PartsDBE DBEnvironment. LOADTABS
uses the following ASCII files, which contain sample data:
•
SupplyBa contains data for the ManufDB.SupplyBatches table.
•
TestData contains data for the ManufDB.TestData table.
•
Inventor contains data for the PurchDB.Inventory table.
•
OrderIte contains data for the PurchDB.OrderItems table.
•
Orders contains data for the PurchDB.Orders table.
•
Parts contains data for the PurchDB.Parts table.
•
Report1 contains data for the PurchDB.Reports table.
•
SupplyPr contains data for the PurchDB.SupplyPrice table.
•
Vendors contains data for the PurchDB.Vendors table.
•
Members contains data for the RecDB.Members table.
•
Clubs contains data for the RecDB.Clubs table.
•
Events contains data for the RecDB.Events table.
• CREAINDX, an ISQL command file containing CREATE INDEX commands.
• CREASEC, an ISQL command file containing SQL commands for granting various
authorities.
Listings of these files appear in the following sections.