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

Try DataDirect Drivers Now

Summary of DataDirect Bulk Load Related Options

The following table summarizes how DataDirect Bulk Load related connection options work with the driver. See "Connection Option Descriptions" for details about configuring the options.
Table 16. Summary: Bulk Load Connection Options
Option
Characteristic
Determines whether the driver treats bulk load operations as synchronous or asynchronous.
If set to 0 (Disabled), bulk load operations are synchronous. The driver does not return from the function that invoked an operation until the operation is complete or the BulkLoadTimeout period has expired. If the operation times out, the driver returns an error.
If set to 1 (Enabled), bulk load operations are asynchronous. The driver returns from the function that invoked an operation after the operation is submitted to the server. The driver does not verify the completion status of the bulk load operation.
Default: 0 (Disabled)
The number of rows that the driver sends to the database at a time during bulk operations.
Default: 1024
Determines whether multiple batches associated with a bulk load operation are processed by Salesforce in parallel or one at a time.
If set to 0 (Serial), multiple batches associated with a bulk load operation are processed one at a time.
If set to 1 (Parallel), multiple batches associated with a bulk load operation are processed in parallel. The order in which the batches are processed can vary.
Default: 1 - Parallel
Specifies the number of seconds the driver waits to request bulk operation status. This interval is used by the driver the first time it requests status and for all subsequent status requests.
Default: 10
Determines when the driver uses bulk load for insert, update, delete, or batch operations.
If set to 0, the driver always uses bulk load to execute insert, update, delete, or batch operations.
If set to x, the driver only uses bulk load if the number of rows to be updated by an insert, update, delete, or batch operation exceeds the threshold. If the operation times out, the driver returns an error.
Default: 4000
The time, in seconds, that the driver waits for a Salesforce bulk job to complete.
A value of zero means there is no timeout.
Default: 0
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