BL_DB2REC= Data Set Option

Specifies the SYSREC data set name for the LOAD utility.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Categories: Bulk Loading
Data Set Control
Default: a generated data set name
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Interaction: In SAS 9.4, the default value for LRECL is 32767. If you are using fixed-length records (RECFM=F), the default value for LRECL is 256.
Data source: DB2 under z/OS
See: BL_DB2LDEXT= data set option, BL_DB2RECSP= data set option, BULKLOAD= data set option

Table of Contents

Syntax

BL_DB2REC=data-set-name

Details

The value of BL_DB2LDEXT= allocates this option. It is initially allocated as SPACE=(cyl,(BL_DB2RECSP, 10%(BL_DB2RECSP)),rlse). The default is a generated data set name, which appears in output that is written to the DB2PRINT data set name. It supports these DCB attributes for existing data sets:

DSORG=PS LRECL=any valid value for RECFM
RECFM=FB BLKSIZE=any valid value for RECFM
Last updated: February 3, 2026