The LIBNAME Statement for Relational Databases

ENABLE_BULK= LIBNAME Option

Allows the connection to process bulk copy when loading data into a Sybase table.

Default value:	YES
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Sybase

Syntax
Syntax Description
Details
See Also

Syntax

ENABLE_BULK=YES | NO

Syntax Description

NO: disables the bulk copy ability for the libref.
YES: enables the connection to perform a bulk copy of SAS data into Sybase.

Details

Bulk copy groups rows so that they are inserted as a unit into the Sybase table. Using bulk copy can improve performance.

If you use both the, ENABLE_BULK= LIBNAME option and the BULKLOAD=data set option, the values of the two options must be the same or an error is returned. However, since the default value of ENABLE_BULK= is YES, you do not have to specify ENABLE_BULK= in order to use the BULKLOAD= data set option.

Note: In SAS 7 and previous releases, this option was called BULKCOPY=. In SAS 8 and later, an error is returned if you specify BULKCOPY=. [cautionend]