HP 3000 Manuals HP 3000 Manuals
Creating a Schema File with SQLGEN
Use option 4 from the SQLSetup menu to create a file that shows all the
data definition commands 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):
__________________________________________________________________________
| |
| |
| WED, AUG 08, 1990, 11:30 AM |
| HP36217-02A.07.00.04 SQL Command Generator HP SQL/UX |
| (C) COPYRIGHT HEWLETT-PACKARD CO. 1986,1987,1988,1989 |
| |
| >> |
| |
__________________________________________________________________________
Figure 4-10. SQLGEN Banner
Respond to the prompts as in the following dialog. For DBEName, enter
hpsql/sampledb/PartsDBE in HP-UX, or PartsDBE in MPE XL.
>> startdbe Return
DBEnvironment Name >> DBEName Return
DBEnvironment successfully started.
>> gen all Return
HP SQL Command Generator for ALL
Schema File Name or '//' to STOP command >> PartsSch Return
Messages are displayed for each of the commands 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.