CA Fast Unload for Db2 for z/OS LOAD-CONTROL parm options continuation to next line.

book

Article ID: 143845

calendar_today

Updated On:

Products

CA Fast Unload for DB2 for z/OS CA Fast Load for DB2 for z/OS CA Database Management for DB2 for z/OS - Utilities Suite

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. The parser reads until column 72 and continues on the next line, no spaces allowed.
This LOAD-CONTROL statement seems to be parsed that way. 

If the parms will reach column 72 you will need to fill right up to column 72 and then start 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


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

LOAD-CONTROL—Generate Load Control Statements