While using Fast Unload for Db2 for z/OS (PFU) to unload data in comma delimited format and
using COMMA parameter x'6A' as the delimiter the unloaded data has x'49' instead of the specified x'6A'.
The user was not specifying the correct CCSID for the source system. The customer environment was operating with a Latin character set.
User initially set CCSID (500,930,932). Site then adjusted to CCSID (1047,930,932).
This produced the correct x'6A' character in the unloaded data.
IBM CCSID 1047 defines x'6A' as a 'Broken bar'. In the Latin America character set the broken bar is a x'49'.
SELECT * FROM authid.table;
Sample data unloaded. Hex On display. Note the x'6A' below that displays as a ¦
000001 '99999 '¦'TEST ALL NINES '¦100¦'A'
In the SYSOUT of the job PFU can be seen adjusting the CCSID to the required target CCSID:
PFU0661I - PFU PROCESSING AN EBCDIC DB2 OBJECT
USING CCSID( 1027, 5035, 4396).
PFU0671I - PFU WILL CONVERT OBJECT DATA TO TARGET
USING CCSID( 1047, 930, 932).