Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 22: Database Creation and Modification

Customizing scripts

Customizing scripts

• Insert scripts at the beginning and end of database creation script
• Insert scripts before and after a table creation command

Inserting begin and end scripts for database creation

In a database creation script, you can insert the following scripts:

Script	Where it is inserted
Begin script	Before the command that creates the database
End script	After the last command in the database creation script

You can use the following variables in these scripts:

Variable	Description
%DATABASE%	Name of the current WAM
%DATE%	Date of script generation
%DBMSNAME%	Name 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
%USER%	Author of the current model

• To insert begin and end scripts for database creation:
  1. Select Dictionary-->Model Definition.

     The model property sheet appears.

  2. Click the Script button.

     The Model Script dialog box appears.

     

  3. Type the DBMS-specific commands to insert in the beginning of the script.

  4. Click the End script radio button.

  5. Type the DBMS-specific commands to insert at the end of the script.

  6. Click OK in each of the dialog boxes.

Inserting begin and end scripts for table creation

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

Script	Where it is inserted
Begin script	Immediately before the table creation command (after the table title)
End script	Immediately after the table 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%	Name of the current WAM
%DATE%	Date of script generation
%DBMSNAME%	Name 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
%TABLE%	Name or code of current table (based on display preferences)
%TCODE%	Code of the current table
%TLABL%	Label of the current table
%TNAME%	Name of the current table
%USER%	Author of the current model

• To insert begin and end scripts for table creation:
  1. Double-click a table symbol.

     The table property sheet appears.

  2. Click the Script button.

     The Table Script dialog box appears. The Begin Script radio button is selected.

     

  3. Type the script that you want to insert before the table creation command.

  4. Click the End Script radio button.

  5. Type the script that you want to insert after the table creation command.

     
     

     Switching between scripts By clicking the Begin Script and End Script radio buttons, you can move back and forth between scripts before validating them.

     
     

  6. Click OK in each of the dialog boxes.

Editing a customized script

Using the script editor, you can insert the following categories of script language into a customized script:

Category	What it inserts in the script
Variable	Variable which is instanciated when the script is generated
Table	Table code
Column	Column code
Join	Parent table code, child table code, or join statement
Function	DBMS-specific function
Operator	Logical operator

Editing a begin or end script for database creation

• To edit a begin or end script for database creation:
  1. Select Dictionary-->Model Properties.

  2. Click the Script button.

  3. Click the button.

     The Model Script Definition dialog box appears.

     

  4. Click the position in the definition textbox where you want to insert the script language.

  5. Select a category from the category list.

     For example, select Variable to display the list of variables.

  6. Select an item from the list for that category.

     For example, select %DATABASE%.

  7. Click the Add button.

     The selected item is inserted at the cursor position.

  8. Click OK in each of the dialog boxes.

Editing a begin or end script for table creation

• To edit a begin or end script for table creation:
  1. Double-click a table symbol.

     The table property sheet appears.

  2. Click the Script button.

  3. Click the button.

     The Table Script Definition dialog box appears.

     

  4. Click the position in the definition textbox where you want to insert the script language.

  5. Select a category from the category list.

     For example, select Variable to display the list of variables.

  6. Select an item from the list for that category.

     For example, select %DATABASE%.

  7. Click the Add button.

     The selected item is inserted at the cursor position.

  8. Click OK in each of the dialog boxes.

Formatting variables in customized scripts

Variables have a syntax that can force a format on their values, as follows:

• Force values to lower-case or upper-case characters
• Truncate the length of values

When a variable does not specify formatting, its values have the same format as in the WAM.

Format code	Format of variable value in script
.L	Lower-case characters
.T	Removes blank spaces
.U	Upper-case characters
.n	Maximum length where n is the number of characters
.nJ	Justifies to fixed length where n is the number of characters

You embed formatting options in variable syntax as follows:

%.format:variable%

For example:

%.L:TABLE%