Data Set Options for Relational Databases |
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
|
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.
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.