BULKLOAD= Data Set Option

Loads rows of data as one unit.
Valid in: DATA and PROC steps
Default: NO
Supports: DB2 UNIX/PC, Oracle
Syntax
Details
See Also

Syntax

BULKLOAD= YES | NO

Syntax Description

YES
calls a DBMS-specific bulk-load facility in order to insert or append rows to a DBMS table.
NO
uses the driver to insert or append data to a DBMS table.

Details

Using BULKLOAD=YES is the fastest way to insert rows into a DBMS table.
When BULKLOAD=YES, the first error encountered causes the remaining rows (including the erroneous row) in the buffer to be rejected. No other errors within the same buffer will be detected. In addition, all rows before the error are committed, even if DBCOMMIT= is set larger than the number of the erroneous row.
For details, see the bulk loading topic in the appropriate data source reference in the DataFlux Federation Server Administrator’s Guide.

See Also

To assign this option to a group of tables or views, use the BULKLOAD= LIBNAME option.
Copyright © SAS Institute Inc. All rights reserved.