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.

SET SCHEMA

Technical documentation

» Table of Contents

» Index

Scope

SQLGEN Syntax

Parameters

Description

Example