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).
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 |
|
These intrinsic functions are not supported for the DBCS data type.