Unload results in PFU0670E messages
Article ID: 15030
Updated On:
Products
Issue/Introduction
Unload results in this error:
PFU0670E - FOUND MULTIPLE CCSIDS FOR COLUMN TYPE CHAR COLUMN
PLEASE SPECIFY A OUTPUT ENCODING SCHEMA USING THE EBCDIC,
ASCII, UNICODE CCSID, OR TRANSLATE COMMANDS.
MULTIPLE ENCODING SCHEME SYSREC OUTPUT IS NOT SUPPORTED.
or
Or PFU0670E - FOUND MULTIPLE CCSIDS FOR COLUMN TYPE TIMESTMP COLUMN
...
Environment
Component: PFU
Resolution
This happens if the SELECT clause joined two or more tables and the encoding scheme was different for one or more of the tables in the JOIN or the SELECT contains multiple encoding schemes as in this example:
SELECT SUBSTR(CAST(TSNAME AS VARCHAR(24) CCSID EBCDIC),1,8), COMPRESS
FROM SYSIBM.SYSTABLEPART WITH UR;
To fix this either:
a) Use a 'EBCDIC' keyword in the SYSIN stream before the SELECTs in question;
FASTUNLOAD
...
OUTPUT-FORMAT DSNTIAUL
EBCDIC <= Note
SELECT SUBSTR(CAST(TSNAME AS VARCHAR(24) CCSID EBCDIC),1,8),
...
or
b) Use the same keyword ‘EBCDIC', as part of your PFU parmlib 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
