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 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.
related tasks
Specifying the collating sequence
Comparing national (UTF-16) data
Controlling the collating sequence with a locale