Message PFU0173E indicating INTO clause not allowed with OUTPUT-FORMAT COMMA-DELIMITED.

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

Description:

Executing CA Fast Unload for DB2 for z/OS (PFU) with keyword OUTPUT-FORMAT COMMA-DELIMITED with an INTO clause and receiving message: PFU0173E - SELECT#01: "INTO" NOT ALLOWED WITH OUTPUT-FORMAT OF "C".

Solution:

Per the PFU User Guide:

---------------------------------------------------------------------  
INTO Clause   Unload Data into the Defined Fields             
                                                              
The INTO clause lets you specify the fields into which        
the data unloads. The field specification describes the       
format and null value identifier of the data to be unloaded.  
All field specifications are listed following the INTO        
clause and are separated by commas.                           
                                                              
Notes:                                                        
- The INTO clause can be used with unloads that specify       
OUTPUT-FORMAT DSNTIAUL, FIXED, or VARIABLE. This clause       
is not supported with other output formats because these      
formats preserve the data in specific formats. No data        
conversions are permitted.                                    
--------------------------------------------------------------------   

Recommend using an alternate OUTPUT-FORMAT such as DSNTIAUL, FIXED, or VARIABLE.  Another option may be to use the CHAR cast function to format the column and still specify OUTPUT-FORMAT COMMA-DELIMITED without the INTO clause:

SELECT CHAR(COL1)        
FROM creator.table;