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

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

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?

Resolution

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.