DB_CASE

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"

Table 8. DB_CASE Values
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"


[ Top of Page | Previous Page | Next Page | Index ]