|
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
|