The LIBNAME Statement for Relational Databases BULKLOAD= LIBNAME Option 73
Default value: not specified
Syntax
BL_OPTIONS=’option ... <option>’
Details
BL_OPTIONS= enables you to pass options to the DBMS bulk load facility when it is
invoked, thereby affecting how data is loaded and processed. You must separate
multiple options with commas and enclose the entire string of options in quotation
marks.
By default, no options are specified. This option takes the same values as the -h
HINT option of the Microsoft BCP utility. Refer to the Microsoft SQL Server
documentation for more information about bulk copy options.
This option is only valid when you are using the Microsoft SQL Server driver or the
Microsoft SQL Server provider on Windows platforms.
ODBC Details: The supported hints are ORDER, ROWS_PER_BATCH,
KILOBYTES_PER_BATCH, TABLOCK, and CHECK_CONSTRAINTS. If you specify
UPDATE_LOCK_TYPE=TABLE, the TABLOCK hint is automatically added.
See Also
To apply this option to an individual data set, see the data set option
“BL_OPTIONS= Data Set Option” on page 159.
BULKLOAD= LIBNAME Option
Determines whether SAS uses a DBMS facility to insert data into a DBMS table
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
ODBC, OLE DB, Teradata
Default value:
NO
Syntax
BULKLOAD=YES | NO
Syntax Description
YES
calls a DBMS-specific bulk load facility in order to insert or append rows to a DBMS
table.
NO
does not call the DBMS bulk load facility.
