SAS/ACCESS Software for Relational Databases: Reference

Data Set Options for Bulk Loading

With each version of SAS/ACCESS software, efforts have been made to increase the performance when loading rows of data into ORACLE tables. In Version 6, the DBLOAD procedure loaded data into an ORACLE table by transactional processing, inserting one or more rows at a time. In Version 7, data was loaded into ORACLE tables using the dynamic SAS/ACCESS LIBNAME engine. Whereas this method still used transactional processing, specifying the INSERTBUFF= data set option significantly improved the load's performance. This option enables you to insert multiple rows at a time.

In Version 8, the SAS/ACCESS engine for ORACLE can call the ORACLE SQL*Loader with its DIRECT=TRUE option in order to improve the loading performance even more. In future releases, SAS/ACCESS software will continue to make use of powerful ORACLE tools to improve its loading performance.

Note: The BULKLOAD=YES option must be specified in order for the other BL_ data set options to work. All of these data set-only options begin with BL_ (for BULKLOAD).

When you specify BULKLOAD=YES, the following SAS/ACCESS options are ignored: DBCOMMIT=, DBFORCE=, ERRLIMIT=, INSERTBUFF=, NULLCHAR=, and NULLCHARVAL=. [cautionend]

Bulk loading is not available on the OS/390 or CMS operating environments.

Chapter Contents
Previous
Next
Top of Page