Unload results in PFU0670E messages

Document ID : KB000015030
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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 

... 

Answer:

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: