HP 3000 Manuals

DBChange Plus User's Guide

PRINT SCHEMA 

Prints the schema of the database, applying any changes stored in the
current change file.

Syntax 

     PR[INT] SC[HEMA] FileName 

Parameters 

FileName            is the name of an MPE XL disk file to which the
                    schema is printed.  Use this parameter interactively
                    or in batch mode.  The file must adhere to MPE XL
                    file naming conventions.  (Refer to the MPE XL 
                    General Users Reference Manual.)

Description 

Use this command to print the database schema.  The printed schema
reflects any changes stored in the current change file.  The schema is
printed on $STDLIST unless output has been redirected by the OUTPUT
command, or the filename parameter is specified in the PRINT SCHEMA
command.  If the filename parameter is specified, a 60000-line, ASCII MPE
XL disk file is created, and the schema is printed to the disk file in a
DBSCHEMA readable format.  If the schema file does not use the 60000
lines of allotted disk space, the unused disk space is returned to the
MPE XL system.

Example 1 

     >print schema salessc 
      Schema is printed.

In this example, the schema is interactively printed to an MPE XL disk
file named SALESSC.

Example 2 

     >print schema ordersz 
      Old schema file ORDERSZ exists.  Purge and create a new file [y/N]? y 
      Schema is printed.

In this example, the schema is interactively printed to an MPE XL disk
file named ORDERSZ. Because the file ORDERSZ already exists, DBChange
returns a message confirming whether or not to purge and create a new
file.

Example 3 

     >print schema ordersz 
      Duplicate schema file.  Cannot process PRINT SCHEMA.

In this example, the schema is printed to an MPE XL disk file named
ORDERSZ in batch mode.  Because the file ORDERSZ already exists, the new
schema file is not created.

Example 4 

     >base orders new 
     >output lp 
     >print schema 

In this example, the schema for the ORDERS database is directed to a
printer.

Example 5 

     >base orders old 
     >:file dbcout;dev=pp,2,3 
     >output lp 
     >print schema 
      Schema is printed.
     >output term 

In this example, the schema for the ORDERS database is directed to
printer PP. The priority is two, and three copies will be printed.

MPE/iX 5.0 Documentation