Previous Page | Next Page

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.


See Also

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page