Batch Processor(RBP) : Unload a table one row per record

Products

• Database Management for DB2 for z/OS - Administration Suite

Issue/Introduction

Batch processor uses a default unload record length of 72. This means it will wrap to the next line after column 72. At times, the table needs to be unloaded one row per record, which means that the record length would be greater than 72.

Can Batch Processor Unload One Row per Record?

 

Environment

Release: R20
Component: RBP

Resolution

Batch Processor supplies a keyword that directs the batch processor to unload a table one row per record. The keyword is ROWLEN([F,V]). It will automatically determine the LRECL and BLKSIZE.

F is for Fixed Length rows, and V is for Variable Length rows.

The ROWLEN keyword can be used inside the .CALL UNLOAD syntax to allow for an LRECL other than the default 72.

The normally generated .ALLOC statement before the .CALL statement included with current Batch Processor UNLOAD model utilities should be deleted and the , DSN & ALLOCATE statements added to the .CALL UNLOAD syntax as below:

.CALL UNLOAD 
.DATA 
  DSN(authid.SYSTABLE.DATA)
  UNIT(SYSDA)
  ALLOCATE(100,60)
  ROWLEN(F)
  SELECT *
  FROM SYSIBM.SYSTABLES
  FOR FETCH ONLY
  ;
  LIMIT(ALL)
.ENDDATA

CALL Statement Parameters

ROWLEN(F|V)
Directs the UNLOAD program to unload the table one row per record. Valid values are:
F : Fixed blocked records.
V : Variable blocked records.
The LRECL and BLKSIZE are determined for you. The LRECL is equal to the maximum length of the row.

ALLOCATE(pripct,secpct)
Specifies how the unload data set space should be allocated.
pripct
Specifies the percentage of the total space that is allocated as a primary quantity.
secpct
Specifies the percentage of the total space that is allocated as a secondary quantity.

Additional Information

UNLOAD Using the UNLOAD Program

CALL Statement Parameters