HP 3000 Manuals

ALLBASE/SQL Reference Manual

Listings of ISQL Command Files 

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.

MPE/iX 5.5 Documentation