INSERTBUFF=

INSERTBUFF=

Specifies the number of rows in a single ORACLE insert.

Default value: Defaults to the value of the LIBNAME option.

Syntax
Details

Syntax

INSERTBUFF=positive-integer

positive-integer: specifies the number of rows to insert.

Details

SAS allows the maximum that is allowed by ORACLE.

Note: When you assign a value that is greater than INSERTBUFF=1, the SAS application notes that indicate the success or failure of the insert operation may be incorrect because these notes only represent information for a single insert, even when multiple inserts are performed. [cautionend]

Note: If specified, the value of the DBCOMMIT= option overrides the value of INSERTBUFF=. [cautionend]

Chapter Contents
Previous
Next
Top of Page