What's new for V5R4
In V5R4, some enhancements have been made to the copy from import file (CPRFRMIMPF) command and the copy to import file (CPYTOIMPF) command.
Enhancements to the CPYTOIMPF command
A remove blank characters (RMVBLANK) parameter has been added for the CPYTOIMPF command. In the previous release, the CPYFRMIMPF command has an RMVBLANK parameter but the CPYTOIMPF command did not have this parameter.
You can use the RMVBLANK parameter to remove leading and trailing blank characters from character and numeric fields when using the CPYTOIMPF command.
The CPYTOIMPF command now directly supports the *TAB special value in the field delimiter (FLDDLM) parameter for the horizontal tab character.
Enhancements to the CPYTOIMPF command and the CPYFRMIMPF command
When the from-file character fields contain a string of blank characters, the CPYTOIMPF command and the CPYFRMIMPF command keep one single blank in the corresponding to-file field, unless you have specified *NONE for the RMVBLANK parameter.
A string escape character (STRESCCHR) parameter has been added to indicate that a string delimiter should be treated as a normal character. This new parameter allows import utilities to parse the delimiter character correctly, when the string delimiter itself is a character in a string field.
A special value *DBLQUOTE is provided as the default value for the string delimiter (STRDLM ) parameter, to indicate that the double quotation mark character is used as string delimiter.
A from CCSID (FROMCCSID) parameter has been added for the CPYTOIMPF command. This parameter can be used to specify the CCSID to be used when the from-file field is 65535.
A to CCSID (TOCCSID) parameter has been added for the CPYFRMIMPF command. This parameter can be used to specify the CCSID to be used when the CCSID of the to-file field is 65535.
How to see what's new or changed
To help you see where technical changes have been made, this information uses:
- The
image to mark where new or changed information begins.
- The
image to mark where new or changed information ends.
To find other information about what's new or changed this release, see the Memo to users.
Parent topic:
Database file management