TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

78 Chapter3
Defining a Database
Schema Processor Operation
Schema Processor Operation
The Schema Processor is a program that accepts a textfile containing the schema as input,
scans the schema and if no errors are detected, optionally produces a root file. The Schema
Processor prints a heading, an optional list of the schema, and summary information on a
listfile.
The Schema Processor executes as either an MPE/iX job or session. For further
information about sessions and jobs, refer to the MPE/iX Commands Reference Manual.
In either case, you must use the following MPE/iX command to initiate execution of the
Schema Processor:
:RUN DBSCHEMA.PUB.SYS
Table 3-5. lists the formal file designators and default actual file designators that the
Schema Processor uses for the text file and list file. The input/output devices to which
$STDINX and $STDLIST refer depend upon the way the system is generated. However,
$STDINX is the standard job or session input device and $STDLIST is the standard job or
session output device.
If you want to equate these files to some other actual file designator, you can use the
MPE/iX FILE command. If a FILE command is included in the job stream, you must inform
the Schema Processor of this in the RUN command in the following way:
:RUN DBSCHEMA.PUB.SYS;PARM= n
where:
n = 1 if an actual file designator has been equated to DBSTEXT.
n = 2 if an actual file designator has been equated to DBSLIST.
n = 3 if actual file designators have been equated to both DBSTEXT and DBSLIST.
NOTE Parm equals 1 or 3 is recommended for large schema files.
Table 3-5. Schema Processor Files
File Use Formal File
Designator
Default Actual File
Designator
textfile Schema and Schema Processor commands DBSTEXT $STDINX
listfile Output listing DBSLIST $STDLIST