Data Set Options for Relational Databases BL_OPTIONS= Data Set Option 159
table is the table name
unique-ID is a number used to prevent collisions in the event of two or more
simultaneous bulk loads of a particular table. The SAS/ACCESS engine generates
the number.
DB2 UNIX/PC Details: If BL_LOG is not specified, the log file is deleted
automatically after a successful operation. See for more information.
Teradata Details: See the bulk load topic in the documentation for the Teradata
interface for more information.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “BL_LOG= LIBNAME Option” on page 72.
BL_METHOD= Data Set Option
Specifies which bulk loading method to use for DB2
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC
Default value: None
Syntax
BL_METHOD= CLILOAD
Syntax Description
CLILOAD
activates the CLI LOAD interface to the LOAD utility. BULKLOAD=YES must also
be specified in order to use the CLI LOAD interface.
BL_OPTIONS= Data Set Option
Passes options to the DBMS bulk load facility, affecting how it loads and processes data
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC, OLE DB, Oracle
Default value: DBMS-specific
Syntax
BL_OPTIONS=’option ... <option>’
