SET_DEFAULT_FILE_CASING¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to set the file casing standard when creating or restructuring tables. By default, all table and column names are created using the specified casing. Passing FILE_CASING_UPPER or FILE_CASING_LOWER will allow the names to be saved in uppercase or lowercase respectively. This can be useful for backwards compatibility where casing was important. Note that the casing standard for a file can also be changed through mertech.ini. Below is a description of the constants that can be passed to this command.

FILE_CASING_UPPER : All created or edited object names will be converted to uppercase. FILE_CASING_LOWER : All created or edited object names will be converted to lowercase. FILE_CASING_KEEP (default) : All created or edited object names will maintain their inputed casing.

Syntax

SET_DEFAULT_FILE_CASING to {constant}

Parameter

Description

constant

FILE_CASING_UPPER, FILE_CASING_LOWER, FILE_CASING_KEEP

Example

SET_DEFAULT_FILE_CASING to FILE_CASING_UPPER