Creating a Schema File with SQLGEN

Use option 4 from the SQLSetup menu to create a file that shows all the data definition statements that were used to build PartsDBE. As an alternative, run the SQLGEN program, as follows:

   sqlgen Return

SQLGEN displays its banner (some details can be different on your system):

   HP36217-02A.F0.00    SQL Command Generator/9000       ALLBASE/SQL

   (C) COPYRIGHT HEWLETT-PACKARD CO.           1986,1987,1988,1989,1990,1991,

   1992 ALL RIGHTS RESERVED.



   >>

Respond to the prompts as in the following dialog. For DBEName, enter hpsql/sampledb/PartsDBE in HP-UX, or PartsDBE in MPE/iX.

   >> startdbe Return

   DBEnvironment Name >> DBEName Return



   DBEnvironment successfully started.



   >> gen all Return



   ALLBASE/SQL Command Generator for ALL



   Schema File Name or '//' to STOP command >> PartsSch Return

Messages are displayed for each of the statements SQLGEN is inserting into the file PartsSch. Below are some of the messages:

   Generating command to START DBE PartsDBE

   Generating command to CREATE DBEFILESET ORDERFS

   Generating command(s) for DBEFILE ORDERDATAF1

   Generating command(s) for DBEFILE ORDERINDXF1

   Generating CREATE TABLE PURCHDB.INVENTORY

   Generating CREATE TABLE PURCHDB.ORDERITEMS

   .

   .

   .

If you created the schema file with SQLSetup, use option 5 to view the file. Otherwise, use an operating system command to examine file PartsSch.