Unload results in PFU0670E messages executing Fast Unload
Article ID: 15030
Updated On:
Products
Issue/Introduction
Fast Unload for Db2 for z/OS (PFU) execution results in this error:
PFU0670E - FOUND MULTIPLE CCSIDS FOR COLUMN TYPE CHAR COLUMN
PLEASE SPECIFY AN OUTPUT ENCODING SCHEME USING THE EBCDIC,
ASCII, UNICODE, CCSID, OR TRANSLATE COMMANDS.
MULTIPLE ENCODING SCHEME SYSREC OUTPUT IS NOT SUPPORTED.
Resolution
Message PFU0670E is seen if the SELECT clause of the unload has joined two or more tables and the encoding scheme was different for one or more of the tables.
The JOIN or the SELECT contains multiple encoding schemes as in this example:
Note: SYSIBM.SYSTABLEPART is a UNICODE table and myauth.SYSCOPY is an EBCDIC table.
SQL-ACCESS EXTENSION
SELECT A.TSNAME , A.COMPRESS, A.STATSTIME,
B.TSNAME , B.TIMESTAMP
FROM SYSIBM.SYSTABLEPART A, myauth.SYSCOPY B
WHERE A.TSNAME = B.TSNAME
WITH UR;
To correct this either:
a) Use a 'EBCDIC' keyword in the SYSIN stream before the SELECTs in question;
FASTUNLOAD
...
OUTPUT-FORMAT DSNTIAUL
EBCDIC <= Note
SQL-ACCESS EXTENSION
SELECT A.TSNAME , A.COMPRESS, A.STATSTIME,
B.TSNAME , B.TIMESTAMP
FROM SYSIBM.SYSTABLEPART A, myauth.SYSCOPY B
WHERE A.TSNAME = B.TSNAME
WITH UR;
or
b) Use the same keyword ‘EBCDIC', as part of your hlq.CDBAPARM(PFU) member used for the PFU execution.
000001 /*********************************************************************/
000002 /* GENERAL PFU PARMLIB DIRECTIVES */
000003 /* */
000004 /* PLEASE NOTE: THIS MEMBER IS CREATED MANUALLY AND DOES NOT HAVE */
000005 /* A PARMLIB EDITOR */
000006 /* */
000007 /*********************************************************************/
000009 EBCDIC
Additional Information
Feedback
