New functions (FORMAT_DATE, FORMAT_NUM, and TO_INCODE) and an improved SUBSTR function
|
The functions FORMAT_DATE, FORMAT_NUM, and TO_INCODE have been added. In addition, the SUBSTR function has been improved.
- FORMAT_DATE:
-
Converts the applicable character string to the specified date format.
- FORMAT_NUM:
-
Converts the applicable character string to the specified numeric format.
- TO_INCODE:
-
Converts the applicable character string to the specified input character encoding.
The external character and user code tables cannot be used.
- SUBSTR:
-
The ADJUST parameter has been added. If the start or end position of variable-length characters (M-type, CSV string, or XML string) is in the middle of the string, you can move the position to the start or end of the string.