AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
X | X | X | X | X | X | X | X | X |
Purpose
Specifies which case to use for SQL commands and converts all characters to either upper or lower case. If this variable is not defined, the default action is to not convert the SQL command characters.
Specify the value of this variable using a DEFINE statement or with the @DTW_ASSIGN() function.
Values
DB_CASE="UPPER"|"LOWER"
Values | Description |
---|---|
UPPER | Converts all SQL command characters to upper case. |
LOWER | Converts all SQL command characters to lower case. |
Examples
Example 1: Specifies upper case for all SQL commands
%DEFINE DB_CASE="UPPER"