ENABLE_BULK= LIBNAME Option

Lets the connection process bulk copy when loading data into a Sybase table.
Valid in: SAS/ACCESS LIBNAME statement
Default: YES
Data source: Sybase
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=.
See: BULK_BUFFER= data set option, BULKLOAD= data set option
Syntax
Details

Syntax

ENABLE_BULK=YES | NO

Syntax Description

NO
disables bulk copy ability for the libref.
YES
lets the connection perform 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, values for both options must be the same or an error is returned. However, because ENABLE_BULK=YES is the default value, you need not specify ENABLE_BULK= to use the BULKLOAD= data set option.
Copyright © SAS Institute Inc. All rights reserved.