Specifies whether to use batch update to write data to your external data source.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | YES [JDBC] |
| YES when BULKLOAD=NO [Hadoop, Spark] | |
| Restriction: | This option applies only if your JDBC driver supports batch updates. |
| Data source: | Hadoop, JDBC, Spark |
| Note: | Support for this option was added in SAS 9.4M9. |
| See: | BULKLOAD= LIBNAME option |
Table of Contents
specifies whether to use batch update to write data to the data source.
There are two different methods that JDBC drivers use to update data in your data source: inserting values via SQL or inserting data via a batch update. Of these, the batch update method is the faster way to write to your data source.