Format category

Chapter 3 DBMS Resource File Reference

Format category

The Format category is located in the Root→Script→SQL category, and contains the following items that define script formatting:

Item	Description
AddQuote	Specifies that object codes are systematically enquoted during the generation. The following settings are available: Yes – Quotes are systematically added to object codes during generation No - Object codes are generated without quotes
CaseSensitivity UsingQuote	Specifies if the case sensitivity for identifiers is managed using double quotes. You should set this boolean to Yes if the DBMS you are using needs double quotes to preserve the case of object codes.
Date and Time formats	See Date and time format.
EnableOwner Prefix / EnableDtbs Prefix	Specifies that object codes can be prefixed by the object owner, the database name, or both, using the %QUALIFIER% variable. The following settings are available: Yes – enables the Owner Prefix and/or Database Prefix check boxes in the Database Generation box. Select one or both of these options to prefix objects. If you select both, the owner and database are concatenated when %QUALIFIER% is evaluated. No - The Owner Prefix and Database Prefix options are unavailable
IllegalChar	[generation only] Specifies invalid characters for names. If there is an illegal character in a Code, the code is set between quotes during generation. Example: +-*/!=<>'"() If the name of the table is "SALES+PROFITS", the generated create statement will be: CREATE TABLE "SALES+PROFITS" Double quotes are placed around the table name to indicate that an invalid character is used. During reverse engineering, any illegal character is considered as a separator unless it is located within a quoted name.
LowerCase Only	When generating a script, all objects are generated in lowercase independently of the model Naming Conventions and the PDM codes. The following settings are available: Yes - Forces all generated script characters to lowercase No - Generates all script unchanged from the way objects are written in the model
MaxScriptLen	Specifies the maximum length of a script line.
UpperCase Only	When generating a script, all objects are generated in uppercase independently of the model Naming Conventions and the PDM codes. The following settings are available: Yes - Forces all generated script characters to uppercase No - Generates all script unchanged from the way objects are written in the model Note that the `UpperCaseOnly` and `LowerCaseOnly` items are mutually exclusive. In the event that both items are enabled, the script is generated in lowercase .