File Category

The File category is located in the Root > Script > SQL category, and contains the following items that define script formatting:

Item

Description

AlterHeader

Specifies header text for a modify database script.

AlterFooter

Specifies footer text for a modify database script.

EnableMultiFile

Specifies that multiple scripts are allowed. The following settings are available:

  • Yes – enables the One File Only check box in the Generate database, Generate Triggers and Procedures, and Modify Database parameters windows. If you deselect this option, a separate script is created for each table (named after the table, and with the extension defined in the TableExt item), and a global script summarizes all the single table script items.

  • The One File Only check box is unavailable, and a single script includes all the statements.

The file name of the global script is customizable in the File Name field of the generation or modification windows and has the extension specified in the ScriptExt item.

The default name for the global script is CREBAS for database generation, CRETRG for triggers and stored procedures generation, and ALTER for database modification.

Footer

Specifies the text for the database generation script footer.

Header

Specifies the text for the database generation script header.

ScriptExt

Specifies the default script extension when you generate a database or modify a database for the first time.

Example:

sql

StartCommand

Specifies the statement for executing a script. Used inside the header file of a multi-file generation to call all the other generated files from the header file.

Example (Sybase ASE 11):

isql %NAMESCRIPT%

Corresponds to the %STARTCMD% variable (see PDM Variables and Macros).

TableExt

Specifies the extension of the scripts used to generate each table when the EnableMultiFile item is enabled and the "One File Only" check box is not selected in the Generate or Modify windows.

Example:

sql

TrgFooter

Specifies footer text for a triggers and procedures generation script.

TrgHeader

Header script for triggers and procedures generation.

TrgUsage1

[when using a single script] Specifies text to display in the Output window at the end of trigger and procedure generation.

TrgUsage2

[when using multiple scripts] Specifies text to display in the Output window at the end of trigger and procedure generation.

TriggerExt

Specifies the main script extension when you generate triggers and stored procedures for the first time.

Example:

trg

Usage1

[when using a single script] Specifies text to display in the Output window at the end of database generation.

Usage2

[when using multiple scripts] Specifies text to display in the Output window at the end of database generation.