Summary of related options for DataDirect Bulk Load
- Last Updated: October 30, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Microsoft SQL Server 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 Threshold (BulkLoadThreshold) | Determines when the driver uses bulk load for insert, update,
delete, or batch operations. If the Enable Bulk Load option is set to 1 and the number of rows affected by an insert, update,
delete, or batch operation exceeds the threshold specified by this option, the driver
uses SQL Server bulk load protocol to perform the operation. 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 Enable Bulk Load option is enabled and 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: 2 |
| Bulk Options (BulkLoadOptions) | Toggles options for the bulk load
process. The value specified is a positive integer representing the cumulative total
of the Bulk Options values. The following bulk load options are available:
If disabled, the bulk load operation continues even if a value that would cause an index to be invalidated is loaded. Default: 2 (Table Lock enabled) |
| Field Delimiter (BulkLoadFieldDelimiter) | Specifies the character that the driver will use to delimit
the field entries in a bulk load data file. Default: None |
| 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.