Fast Unload execution receives syntax error messages PFU0011E and PFU0096E when specifying INTO clause.

Products

• Fast Unload for DB2 for z/OS

Issue/Introduction

Fast Unload for Db2 for z/OS (PFU) execution receives the following syntax error messages when using an INTO specification with INTEGER  EXTERNAL specified:

SELECT COL1 INTO
COL1 INTEGER  EXTERNAL

1...5....10...15...20...25...30...35...40...45...50...55...60...65...70...75
PFU0011E - SYNTAX ERROR ON OR NEAR LOCATION 041
PFU0096E - FORMAT ERROR IN FIELD SPECIFICATION - SEE DOCUMENTATION

Cause

The syntax errors are related to 2 blank spaces between the keywords INTEGER and EXTERNAL

Resolution

For the INTO keyword options such as INTEGER EXTERNAL only specify a single blank space between the keywords INTEGER and EXTERNAL.