 |
» |
|
|
|
Both SQLSetup and CREASQL
use a group of ISQL command files to create and load local
copies of PartsDBE. These files, located in
SAMPLEDB.SYS,
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.
|
