search cancel

FAST UNLOAD : Unload results in PFU0670E messages

book

Article ID: 15030

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS

Issue/Introduction

Unload 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.

Environment

Release: R20
Component: PFU

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

EBCDIC—Translate Data to EBCDIC

Customize the Product Using PFU Parmlib

PFU0670E

EBCDIC—Translate Data to EBCDIC