Data Set Options for Relational Databases

BL_DB2LDCT1= Data Set Option

Specifies a string in the LOAD utility control statement between LOAD DATA and INTO TABLE.

Default value:	none
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_DB2LDCT1='string'

Details

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

This option specifies a string that contains a segment of the Load Utility Control Statement between 'LOAD DATA' and 'INTO TABLE'. Valid control statement options include but are not limited to RESUME, REPLACE, LOG, and ENFORCE.

You can use DB2 bulk-load control options (BL_DB2LDCT1=, BL_DB2LDCT2=, and BL_DB2DCT3= options to specify sections of the control statement, which the engine incorporates into the control statement that it generates. These options have no effect when BL_DB2LDEXT=USERUN. You can use these options as an alternative to specifying BL_DB2LDEXT=GENONLY and then editing the control statement to include options that the engine cannot generate. In some cases, it is necessary to specify at least one of these options--for example, if you run the utility on an existing table where you must specify either RESUME or REPLACE.

The LOAD utility requires that the control statement be in uppercase--except for objects such as table or column names, which must match the table. You must specify values for DB2 bulk-load control options using the correct case. SAS/ACCESS Interface to DB2 under z/OS cannot convert the entire control statement to uppercase because it might contain table or column names that must remain in lower case.