Unload results in PFU0670E messages

Products

• CA Database Analyzer for DB2 for z/OS
• CA Fast Unload for DB2 for z/OS
• CA Fast Check for DB2 for z/OS
• CA Fast Index for DB2 for z/OS
• CA Fast Load for DB2 for z/OS
• CA Rapid Reorg for DB2 for z/OS

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

Release:
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

EBCDIC—Translate Data to EBCDIC

Customize the Product Using PFU Parmlib

PFU0670E