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