Executing CA Fast Unload with FILL YES keyword and receiving: PFU0012E - INVALID KEYWORD.

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

Question:

Executing CA Fast Unload for DB2 for z/OS (PFU) with the FILL YES keyword specified and receiving the following syntax error:

PFU0012E - INVALID KEYWORD ON OR NEAR LOCATION nnn

How should the FILL YES keyword be specified?

 

Answer:

First verify the following PTFs are implemented:

R18 - RO89781
R19 - RO91313

Some additional notes for the FILL YES|NO keyword:

- FILL YES does not work with OUTPUT-FORMAT EXTERNAL by design.  FILL NO is always used by OUTPUT-FORMAT EXTERNAL. 

- The FILL YES|NO keyword would typically be used when INTO statements are specified with column type EXTERNAL specified. OUTPUT-FORMAT EXTERNAL does not support INTO statements (A CA Fast Unload error message is returned in this instance). 

- The FILL YES|NO keyword is a global keyword.