Chapter 3 DBMS Resource File Reference

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.
EnableMulti
File 		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).
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.

 

Copyright (C) 2008. Sybase Inc. All rights reserved.