CA Fast Unload for Db2 for z/OS : LOAD-CONTROL parm options continuation to next line.
Article ID: 143845
Updated On:
Products
Issue/Introduction
It does not appear possible to extend LOAD-CONTROL options over multiple lines with CA Fast Unload for Db2 for z/OS.
Tried ending a line with a comma or starting next line with a comma and neither work.
LOAD-CONTROL DB2LOAD,EST-ROWS,ENFORCE-NO
,DISCARDS=1,IGNOREFIELDS
,SYSTEMPERIOD,PERIODOVERRIDE
,TRANSIDOVERRIDE,BUSINESSPERIOD
results in:
LOAD-CONTROL DB2LOAD,EST-ROWS,ENFORCE-NO
,DISCARDS=1,IGNOREFIELDS
1...5....10...15...20...25...30...35...40...45...50...55...
PFU0011E - SYNTAX ERROR ON OR NEAR LOCATION 005
PFU0255I - UTILID - DXP5048.DXP5048E - CHECKSUM - 00000
Environment
Release : R19, R20
Component : CA Fast Unload for DB2 for z/OS
Resolution
There is no continuation character. This LOAD-CONTROL statement is parsed by reading until column 72 and continues on the next line, no spaces allowed.
If the parms reach column 72 the line must be filled right up to column 72 and then starting again in column one on the next line even if it breaks a parm in two thus:
----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
LOAD-CONTROL DB2LOAD,EST-ROWS,ENFORCE-NO,DISCARDS=1,IGNOREFIELDS,SYSTEM
PERIOD,PERIODOVERRIDE,TRANSIDOVERRIDE,BUSINESSPERIOD
Notice the SYSTEMPERIOD parm above has been truncated on the first line at column 72 and continued without a space on the next in column one.
Another solution available is to use multiple LOAD-CONTROL cards thus:
LOAD-CONTROL FASTLOAD,EST-ROWS,ENFORCE-NO,DISCARDS=1,IGNOREFIELDS
LOAD-CONTROL FASTLOAD,SYSTEMPERIOD,PERIODOVERRIDE,BUSINESSPERIOD
LOAD-CONTROL FASTLOAD,TRANSIDOVERRIDE
Additional Information
Feedback
