Executing 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?
First verify the following PFU 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 Fast Unload error message is returned in this instance).
- The FILL YES|NO keyword is a global keyword.