 |
» |
|
|
|
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. |
