skip to main content
Connection property descriptions : BulkLoadOptions
  

Try DataDirect Drivers Now

BulkLoadOptions

Purpose

Enables bulk load protocol options for batch inserts that the driver can take advantage of when EnableBulkLoad is set to a value of true.

Valid values

This value is the cumulative value of all enabled options. The following list describes the value and the corresponding option that is enabled:
Value
Option Enabled
1
The KeepIdentity option preserves identity values. If unspecified, identity values are ignored in the source and are assigned by the destination.
2
The TableLock option assigns a table lock for the duration of the bulk copy operation. Other applications cannot update the table until the operation completes. If unspecified, the default bulk locking mechanism specified by the database server is used.
16
The CheckConstraints option checks integrity constraints while data is being copied. If unspecified, constraints are not checked.
32
The FireTriggers option causes the database server to fire insert triggers for the rows being inserted into the database. If unspecified, triggers are not fired.
64
The KeepNulls option preserves null values in the destination table regardless of the settings for default values. If unspecified, null values are replaced by column default values where applicable.

Behavior

If set to 0, all the options are disabled.

Example

A value of 67 means the KeepIdentity, TableLock, and KeepNulls options are enabled (1 + 2 + 64).

Data source method

setBulkLoadOptions

Default

2

Data type

Long

See also

*DataDirect Bulk Load
*Bulk load properties