Inserting Begin and End Script for Tablespace Creation

For each tablespace, you have the option to insert the following scripts:

Script

Where it is inserted

Begin script

Immediately before the tablespace creation command (after the table title)

End script

Immediately after the tablespace creation command

These scripts can appear in database creation scripts and database modification scripts.

You can use the following variables in these scripts:

Variable

Description

%DATABASE%

Code of the current PDM

%DATE%

Date of script generation

%DBMSNAME%

Code of the DBMS for the target database

%NAMESCRIPT%

Filename of script file

%PATHSCRIPT%

Filename and path of script file

%STARTCMD%

Command that runs the script

%TABLESPACE%

Code of the tablespace

%OPTIONS%

Physical options of the tablespace

%AUTHOR%

Author of the current model
  1. Double-click a tablespace in the list of tablespace.

    The tablespace property sheet is displayed.

  2. Click the Script tab.

    The Script tab opens to the Begin tab.

  3. Type the DBMS-specific commands to insert in the beginning of the script.
  4. Click the End tab at the bottom of the tab.
  5. Type the DBMS-specific commands to insert at the end of the script.
  6. Click OK.
Parent topic: Customizing Scripts

Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com