Specifies a string in the LOAD utility control statement between LOAD DATA and INTO TABLE.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under z/OS |
| See: | BULKLOAD= data set option, BL_DB2LDCT2= data set option, BL_DB2DCT3= data set optionBL_DB2LDEXT= data set option |
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=) 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 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. An example is running 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 lowercase.