The LIBNAME Statement for Relational Databases

BL_OPTIONS= LIBNAME Option

Passes options to the DBMS bulk-load facility, which affects how it loads and processes data.

Default value:	not specified
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	ODBC, OLE DB

Syntax
Details
See Also

Syntax

BL_OPTIONS='option <..., option>'

Details

You can use BL_OPTIONS= to pass options to the DBMS bulk-load facility when it is called, 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. See the Microsoft SQL Server documentation for more information about bulk copy options.

This option is valid only when you use the Microsoft SQL Server driver or the Microsoft SQL Server provider on Windows platforms.

ODBC: 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.