TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

Chapter 3 79
Defining a Database
Schema Processor Operation
Table 3-6. shows sample combinations of MPE/iX RUN and FILE commands that can be
used to initiate DBSCHEMA execution.
Only the first 72 characters of each text file record are processed.
If the schema is error-free, a root file is created, given the same name as the one specified
for the database in the schema, initialized, and saved as a catalogued disk file. To process
the schema without creating a root file, use the NOROOT option of the $CONTROL
command. For more information, refer to "Schema Processor Commands" later in this
chapter.
Creating the Text File
A convenient method for creating the input file is to use a text editor, for example,
EDIT/3000, to enter the commands and schema in a disk file.
Figure 3-2. illustrates this process in a sample session that also executes the Schema
Processor. The example shown in Figure 3-2. uses EDIT/3000.
The steps to follow are listed below and correspond to the numbers in Figure 3-2.
1. Initiate an MPE/iX session by logging on with the appropriate user name and account.
2. Initiate text editor execution. Enter an Editor ADD command in response to the first
prompt.
3. Enter Schema Processor commands and the schema itself into records of the Editor
work file.
4. Save the work file in a disk file named ORDERSSC. Then terminate the Editor.
5. Use the MPE/iX FILE command to equate the formal file designator DBSLIST to the
line printer and DBSTEXT to the disk file ORDERSSC.
6. Initiate execution of DBSCHEMA and indicate that the text file and list file have been
defined in FILE commands. When the Schema Processor has finished processing the
schema, it prints the number of error messages and verifies that the root file has been
created.
Table 3-6. Examples of RUN and FILE Commands
:RUN DBSCHEMA.PUB.SYS Uses all default files. Prompts for lines of schema in
session mode.
:FILE DBSTEXT=ORDERSSC
:RUN DBSCHEMA.PUB.SYS;PARM=1
Processes schema from a user disk text file named
ORDERSSC. Outputs listing to $STDLIST.
:FILE DBSLIST;DEV=LP
:RUN DBSCHEMA.PUB.SYS;PARM=2
Prompts for lines of schema and outputs the listing to a
line printer.
:FILE DBSTEXT=ORDERSSC
:FILE DBSLIST=ORDERLST
:RUN DBSCHEMA.PUB.SYS;PARM=3
Processes schema from user text file named ORDERSSC;
outputs the listing to a disk text file named ORDERLST.