Variables for Database Generation, and Triggers and Procedures Generation

You can use the following variables:

Variable

Comment

%DATE%

Generation date & time

%USER%

Login name of User executing Generation

%PATHSCRIPT%

Path where File script is going to be generated

%NAMESCRIPT%

Name of File script where SQL orders are going to be written

%STARTCMD%

Description to explain how to execute Generated script

%ISUPPER%

TRUE if upper case generation option is set

%ISLOWER%

TRUE if lower case generation option is set

%DBMSNAME%

Name of DBMS associated with Generated model

%DATABASE%

Code of Database associated with Generated model

%USE_SP_PKEY%

Use stored procedure primary key to create primary keys (SQL Server specific)

%USE_SP_FKEY%

Use stored procedure foreign key to create primary keys (SQL Server specific)


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