Summary of related options for DataDirect Bulk Load
- Last Updated: November 1, 2024
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
| Connection Options: Bulk | Description |
|---|---|
| Batch Size (BulkLoadBatchSize) | 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 |
| Bulk Binary Threshold (BulkBinaryThreshold) | 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 |
| Bulk Character Threshold (BulkCharacterThreshold) | 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 |
| Bulk Load Options (BulkLoadOptions) | 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 |
| Field Delimiter (BulkLoadFieldDelimiter) | Specifies the character that the driver will use to delimit the
field entries in a bulk load data file. Default:
|
| Record Delimiter (BulkLoadRecordDelimiter) | 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.