Data Set Options for Relational Databases

BL_DB2IN= Data Set Option

Specifies the SYSIN 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_DB2IN=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=(trk,(10,1),rlse) with the default being a generated data set name, which appears in the DB2PRINT output, with these DCB attributes:

	DSORG=PS
	RECFM=VB
	LRECL=516
	BLKSZE=23476.

It supports these DCB attributes for existing data sets:

	DSORG=PS
	RECFM=F, FB, FS, FBS, V, VB, VS, or VBS
	LRECL=any valid value for RECFM, which is < 32,760
	BLKSIZE=any valid value for RECFM, which is < 32,760.