Converting data to uppercase

In a File Manager/Db2 editor session, the CAPS and CASE primary commands control whether data in the data area is converted to uppercase on input (CAPS, CAPS ON or CASE UPPER), or left alone (CASE, CASE MIXED or CAPS OFF; this is the default action).

You can abbreviate the CAPS command to CAP and the CASE command to CAS.

The CAPS ON and CASE UPPER commands have slightly different effects.

CAPS or CAPS ON is similar to the ISPF editor CAPS command:
  • If you overtype any data in a row, only the current column is converted to uppercase.
  • The CHANGE command treats the new (replacement) string as if it were specified in all uppercase unless:
    • The new string is enclosed in single quotation marks, prefixed by the letter C (for example, C'New String'), or
    • The new string is specified as a hexadecimal string (for example, X'C1C2C3')

    If either of the previous conditions apply, the new string is not converted to uppercase.

CAPS or CAPS ON affects only rows changed after the CAPS or CAPS ON command is entered.

CASE UPPER converts all data in any new or changed rows to uppercase, regardless of how the rows are changed. CASE UPPER affects all rows inserted or changed in the current FM/Db2 editor session, including rows inserted or changed before the CASE UPPER command is entered.

The CAPS OFF, CASE, and CASE MIXED commands have the same effect: they turn off conversion to uppercase.

Any CAPS command overrides any previously entered CASE command, and any CASE command overrides any previously entered CAPS command.

Note:
  1. In the ISPF editor with CAPS ON, a line is considered changed if you type anything on the line (if you overtype a space with a space, it is considered to be a change). However, in the FM/Db2 editor, overtyping a character with the same character is not considered a change.
  2. The values for CASE and CAPS are not maintained between FM/Db2 editor sessions. Each new FM/Db2 editor session begins with CAPS OFF; that is, data entered in lowercase is not converted to uppercase.

Related concepts

Related tasks

Related references