Intrinsic functions that depend on collating sequence

The following intrinsic functions depend on the ordinal positions of characters.

For an ASCII code page, these intrinsic functions are supported based on the collating sequence in effect. For an EUC code page or a code page that includes DBCS characters, the ordinal positions of single-byte characters are assumed to correspond to the hexadecimal representations of the single-byte characters. For example, the ordinal position for 'A' is 66 (X'41' + 1) and the ordinal position for '*' is 43 (X'2A' + 1).

Table 1. Intrinsic functions that depend on collating sequence
Intrinsic function Returns: Comments
CHAR Character that corresponds to the ordinal-position argument  
MAX Content of the argument that contains the maximum value The arguments can be alphabetic, alphanumeric, national, or numeric.1
MIN Content of the argument that contains the minimum value The arguments can be alphabetic, alphanumeric, national, or numeric.1
ORD Ordinal position of the character argument  
ORD-MAX Integer ordinal position in the argument list of the argument that contains the maximum value The arguments can be alphabetic, alphanumeric, national, or numeric.1
ORD-MIN Integer ordinal position in the argument list of the argument that contains the minimum value The arguments can be alphabetic, alphanumeric, national, or numeric.1
  1. Code page and collating sequence are not applicable when the function has numeric arguments.

These intrinsic functions are not supported for the DBCS data type.