File Category (DBMS)

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.