The LIBNAME Statement for Relational Databases |
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
|
BL_OPTIONS='option <..., option>'
|
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.
To apply this option to an individual data set, see
the
BL_OPTIONS= Data Set Option.
UPDATE_LOCK_TYPE= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.