BL_DB2LDEXT= Data Set Option

Specifies the mode of execution for the DB2 LOAD utility.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: GENRUN
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: DB2 under z/OS
See: BULKLOAD= data set option

Syntax

BL_DB2LDEXT=GENRUN | GENONLY | USERUN

Syntax Description

GENRUN
generates the control (SYSIN) file and the data (SYSREC) file, and runs the utility with them.
GENONLY
generates the control (SYSIN) file and the data (SYSREC) file but does not run the utility. Use this method when you need to edit the control file or to verify the generated control statement or data before you run the utility.
USERUN
uses existing control and data files, and runs the utility with them. Existing files can be from a previous run or from previously run batch utility jobs. Use this method when you restart a previously stopped run of the utility.
All valid data sets that the utility accepts are supported when BL_DB2LDEXT=USERUN. However, syntax errors from the utility can occur because no parsing is done when reading in the SYSIN data set. Specifically, neither embedded comments (beginning with a double hyphen, '--') nor columns 73 through 80 of RECFM=FB LRECL=80 data sets are stripped from the control statement. The solution is to remove embedded comments and columns 73 through 80 of RECFM=FB LRECL=80 data sets from the data set. However, this is not an issue when you use engine-generated SYSIN data sets because they are RECFM=VB and therefore have no embedded comments.

Details

This option specifies the mode of execution for the DB2 LOAD utility, which involves creating data sets that the utility needs and to call the utility.