CASE command

Usage

Use the CASE command to differentiate between lowercase and uppercase values for DB2® PE identifiers. Specify CASE (SENSITIVE) before other commands if you want the commands to differentiate between uppercase and lowercase values. If no CASE command is specified or if you specify CASE (ANY), there is no differentiation between lowercase characters and uppercase characters.

Usage notes

• The CASE command affects all of the commands listed below it.
• You should usually list the CASE command first so that it affects all of the commands in the execution.

Syntax

           .-SENSITIVE-.
>>-CASE--(-+-ANY-------+-)-------------------------------------><
 

Subcommand options

The syntax diagram shows the options that are available with this subcommand. The following list gives descriptions of these options.

SENSITIVE

Differentiates between uppercase and lowercase values.

ANY

Does not differentiate between uppercase and lowercase values.

Examples using the CASE command

In these examples, there are two correlation names: driver and DRIVER. They are differentiated by their case.

In this example, CASE(SENSITIVE) is specified. Data related to the lower case correlation name driver is retrieved:

·
·
·

CASE(SENSITIVE)
GLOBAL
	INCLUDE (IFCID (3,239))
	INCLUDE (CORRNAME (driver))
EXEC
/*

In this example, CASE(SENSITIVE) is specified. Data related to the uppercase correlation name DRIVER is retrieved:

·
·
·

CASE(SENSITIVE)
GLOBAL
	INCLUDE (IFCID (3,239))
	INCLUDE (CORRNAME (DRIVER))
EXEC
/*

In this example, CASE(ANY) is specified. Data related to the lowercase correlation name driver and the uppercase correlation name DRIVER is retrieved:

·
·
·

CASE(ANY)
GLOBAL
	INCLUDE (IFCID (3,239))
	INCLUDE (CORRNAME (driver))
EXEC
/*

In this example, CASE is not specified. Data related to the lowercase correlation name driver and the uppercase correlation name DRIVER is retrieved:

·
·
·

GLOBAL
	INCLUDE (IFCID (3,239))
	INCLUDE (CORRNAME (driver))
EXEC
/*