An application can call Bulk-Library routines to copy data from program variables into a database table.
When copying into a database, the chief advantage of bulk copy over the SQL insert alternative is speed.
When copying data into a non-indexed table, the high speed version of bulk copy is used. Adaptive Server performs no data logging during high-speed transfers. If the system fails before the transfer is complete, no new data will remain in the database. Because high-speed transfer affects the recoverability of the database, it is enabled only when the Adaptive Server option select into/bulkcopy has been turned on. An application can call the Adaptive Server system procedure sp_dboption to turn this option on or use the Client-Library connection property CS_BULK_LOGIN.
If the select into/bulkcopy option is not turned on and a user tries to copy data into a table that has no indexes, Adaptive Server generates an error message.
After a bulk-copy operation is complete, the System Administrator should dump the database to ensure its future recoverability.
When copying data into an indexed table, a slower version of bulk copy is automatically used, and row inserts are logged.
