Fast Logged Bulk Insert

Adaptive Server version 15.7 ESD #2 allows you to fully log bcp in fast mode, providing full data recovery.

Previous versions of bcp in fast mode logged only page allocations. See Adaptive Server Enterprise 15.7 ESD #2 documentation.

In jConnect for JDBC, set ENABLE_BULK_LOAD connection property to the new value LOG_BCP to enable full logging.

In ODBC Driver, set EnableBulkLoad connection property to new value 3 to enable full logging. Alternatively, set the SQL_ATTR_ENABLE_BULK_LOAD connection attribute to the desired level in the ODBC application:

sr = SQLSetConnectAttr(hdbc, SQL_ATTR_ENABLE_BULK_LOAD, (SQLPOINTER)3, SQL_IS_INTEGER);

This allows a single connection to use different types of bulk load.

In ADO.NET Provider, set EnableBulkLoad connection property to new value 3 to enable full logging.