Summary of Related options for DataDirect Bulk Load
- Last Updated: January 29, 2018
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
The following table summarizes how DataDirect Bulk Load related connection options work with the drivers. See "Connection Option Descriptions" in each driver chapter for details about configuring the options.
| Option | Characteristic |
|---|---|
| Batch Size | An integer value that specifies the number of rows at a time that the driver sends to the database during bulk operations. |
| Bulk Binary Threshold | An integer value that specifies the maximum size, in KB, of binary data exported to the bulk data file. Any data exceeding this size is exported to an external file. |
| Bulk Character Threshold | An integer value that specifies the maximum size, in KB, of character data exported to the bulk data file. Any data exceeding this size is exported to an external file. |
| Bulk Options | Toggles options for the bulk load process. |
| Field Delimiter | Specifies the character that the driver will use to delimit the field entries in a bulk load data file. |
| Record Delimiter | Specifies the character that the driver will use to delimit the record entries in a bulk load data file. |