Data Set Options for Relational Databases

BL_DB2REC= Data Set Option

Specifies the SYSREC data set name for the LOAD utility.

Default value:	a generated data set name
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS Support:	DB2 under z/OS

Syntax
Details
See Also

Syntax

BL_DB2REC=data-set-name

Details

To specify this option, you must first set BULKLOAD=YES.

This option is allocated based on the value of BL_DB2LDEXT=. It is initially allocated as SPACE=(cyl,(BL_DB2RECSP, 10%(BL_DB2RECSP)),rlse) with the default being 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
	RECFM=FB
	LRECL=any valid value for RECFM
	BLKSIZE=any valid value for RECFM.