SAS/ACCESS Interface to JDBC implements the BULKLOAD= LIBNAME option differently from other SAS/ACCESS interfaces. For JDBC, an external bulk-loading program is not called to implement bulk loading. Instead, BULKLOAD=YES means that data is loaded with the JDBC batch update facility. Batch update is generally the fastest method to insert data into a database using a JDBC driver when there is not an external program for bulk loading. BULKLOAD=YES is the default for SAS/ACCESS Interface to JDBC.
Some JDBC drivers do
not support batch update. If the JDBC driver reports via the JDBC
DataBaseMetaData that batch updates are not supported, then SAS/ACCESS
Interface to JDBC automatically acts as if BULKLOAD=NO. Alternatively,
you can manually specify BULKLOAD=NO. When BULKLOAD=NO, SAS/ACCESS
Interface to JDBC attempts to insert data into the target database
using an SQL query that uses the INSERT INTO <table>
VALUES <values> clause. Some databases support
multiple VALUES clauses that so that you
can insert many rows in a single INSERT clause.