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

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

Issue:

CA 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.