HP 3000 Manuals

ALLBASE/SQL Database Administration Guide

SET SCHEMA 

Defines the schema file name to be used by the generate commands.

Scope 

SQLGEN Only

SQLGEN Syntax 

>> SE[T] SCH[EMA]  Schema File Name or '//' to STOP command >>

SchemaFileName 

Parameters 

SchemaFileName          is the name of the schema file you wish to
                        define.

Description 

With SET SCHEMA you can define a schema file name before entering
generate commands.  The generate commands issued subsequently do not
prompt for a schema file name.  Instead they place commands into the
schema file you have defined.  This allows you to automatically place all
generated commands in one schema file if you wish.  Commands are appended
to the end of the file as they are generated.

Example 

     >> set schema 
     Current Schema File:  schema1

     Enter Schema File Name, RETURN to reset, or '//' to keep current name.

     Schema File Name or "//" to STOP command >> schema2 

     Current Schema File:  schema2

     >>


NOTE  Because special schema files are required by the GENERATE LOAD
      command, you cannot use the SET SCHEMA command to define schema
      file names for the the GENERATE LOAD command.

MPE/iX 5.5 Documentation