IBM Books

Reference

DB_CASE


AIX HP-UX Linux OS/2 OS/390 OS/400 SCO 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 | Table of Contents | Index ]