Passes to the DBMS bulk-load facility options that affect how it loads and processes data.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Alias: | BCP_OPTIONS= [Microsoft SQL Server, ODBC] |
| Default: | none |
| Restriction: | ODBC, OLE DB: This option is valid only when you use the Microsoft SQL Server driver or the Microsoft SQL Server provider on Windows platforms. |
| Requirements: | Amazon Redshift: To specify this option, you must first set BULKUNLOAD=YES. |
| ODBC, OLE DB: To specify this option, you must first set BULKLOAD=YES. | |
| Data source: | Amazon Redshift, Microsoft SQL Server, ODBC, OLE DB |
| Note: | Support for Microsoft SQL Server was added in SAS 9.4M7. |
| See: | BL_OPTIONS= data set option, BULKLOAD= LIBNAME option, BULKLOAD= data set option, BULKUNLOAD= LIBNAME option, UPDATE_LOCK_TYPE= LIBNAME option |
Table of Contents
specifies a bulk-load option that you want to set.
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 enclose the entire string of one or more options in quotation marks. Separate multiple options with commas.
Microsoft SQL Server: This option is used to support bulk loading when you access Azure Synapse Analytics (SQL DW) using an Azure Data Lake Gen2 account. Options should be specified as they are used by the WITH clause in the COPY INTO command for Azure Synapse Analytics (SQL DW). For example, you can specify the Azure FIELDTERMINATOR option within the BL_OPTIONS= string instead of specifying the BL_DELIMITER= LIBNAME option.
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.
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.