LOAD-CONTROL parameter options continuation to next line executing Fast Unload
search cancel

LOAD-CONTROL parameter options continuation to next line executing Fast Unload

book

Article ID: 143845

calendar_today

Updated On:

Products

Fast Unload for DB2 for z/OS Fast Load for DB2 for z/OS 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 Fast Unload for Db2 for z/OS (PFU).

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      

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