BULKCOPY=

BULKCOPY=

Calls the SYBASE bulk copy utility.

Default value: NO

Aliases: BULK=, DBNOLOG=

Syntax
Details

Syntax

BULKCOPY=YES | NO

YES: calls the SYBASE bulk copy utility when you load data into a SYBASE table.
NO: does not call the SYBASE bulk copy utility.

Details

This utility groups rows so that they are inserted as a unit into a SYBASE table. Using this utility can improve performance.

If you specify BULKCOPY=YES, the SYBASE bulk copy utility is enabled and the connection to do the bulk copying is enabled. The LIBNAME option ENABLE_BULK= works in conjunction with the BULKCOPY= data set option. The LIBNAME ENABLE_BULK= option is YES by default, but the BULKCOPY= data set option is NO by default. Therefore, you must set BULKCOPY=YES to perform the bulk load.

If you specify BULKCOPY=NO, or omit the BULKCOPY= option (leaving the default value of NO), the bulk copy utility is not enabled.

For examples that use the BULKCOPY= options, see Example 1: Specifying a LIBNAME Statement to Access SYBASE Data.

BULKCOPY= can also be specified with the BULK= and DBNOLOG= aliases.

Chapter Contents
Previous
Next
Top of Page