skip to main content
Using the Driver : Using DataDirect Bulk Load : Summary of Related Options for DataDirect Bulk Load
  

Try DataDirect Drivers Now

Summary of Related Options for DataDirect Bulk Load

Connection Options: Bulk
Description
The number of rows that the driver sends to the database at a time during bulk operations. This value applies to all methods of bulk loading.
Default: 1024
The maximum size, in KB, of binary data that is exported to the bulk data file.
If set to -1, all binary data, regardless of size, is written to the bulk data file, not to an external file.
If set to 0, all binary data, regardless of size, is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
If set to x, any binary data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
Default: None
The maximum size, in KB, of character data that is exported to the bulk data file.
If set to -1, all character data, regardless of size, is written to the bulk data file, not to an external file.
If set to 0, all character data regardless of size, is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
If set to x, any character data exceeding this specified number of KB is written to an external file, not the bulk data file. A reference to the external file is written to the bulk data file.
Default: -1
Toggles options for the bulk load process.
If set to 128 (no index errors is enabled), the driver stops a bulk load operation when a value that would cause an index to be invalidated is loaded. For example, if a value is loaded that violates a unique or non-null constraint, the driver stops the bulk load operation and discards all data being loaded, including any data that was loaded prior to the problem value.
If disabled, the bulk load operation continues even if a value that would cause an index to be invalidated is loaded.
Default: Disabled
Specifies the character that the driver will use to delimit the field entries in a bulk load data file.
Default: None
Specifies the character that the driver will use to delimit the record entries in a bulk load data file.
Default: None
See "Connection Option Descriptions" for details about configuring the options.