skip to main content
Connection Option Descriptions : Enable Bulk Load
  

Try DataDirect Drivers Now

Enable Bulk Load

This information pertains to Windows This information pertains to UNIX/Linux
Supported on Windows, UNIX, and Linux only.

Attribute

EnableBulkLoad (EBL)

Purpose

Specifies the bulk load method.
To override the value set by this connection option for an individual statement, set a different value in the SQL_ATTR_BULK_LOAD_ENABLED statement attribute (attribute value 1062) on the SQLSetStmtAttr() function. Setting the attribute has the same behavior as setting this connection option. To enable this option, set a value of SQL_TRUE. To disable, set a value of SQL_FALSE. This statement is defined in the qesqlext.h file, which is installed with the driver.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver uses the database bulk load protocol when an application executes an INSERT with multiple rows of parameter data. If the protocol cannot be used, the driver returns a warning.
If set to 0 (Disabled), the driver uses standard parameter arrays.

Statement Attribute

To override the value set by this connection option for an individual statement, set a different value in the SQL_ATTR_BULK_LOAD_ENABLED statement attribute on the SQLSetStmtAttr() function. Specify one of the following values when using
If set to 1 (Enabled), the driver uses the database bulk load protocol when an application executes an INSERT with multiple rows of parameter data. If the protocol cannot be used, the driver returns a warning.
If set to 0 (Disabled), the driver uses standard parameter arrays.

Default

0 (Disabled)

GUI Tab

Bulk Tab

See Also

Performance Considerations