ODBC Data Batching Considerations

Certain considerations for the ODBC data batching feature.

  • This feature supports only statements and stored procedures that do not return a result set or have an output parameter.

  • Asynchronous mode is not supported. While in batch mode, the application cannot execute any statement on the same connection other than the one being batched.

  • SQL_DATA_AT_EXEC is not supported. Bind LOB parameters as normal parameters.

  • When batching data without binding parameter arrays and SQL_ATTR_PARAM_STATUS_PTR is set, Adaptive Server Enterprise ODBC Driver retrieves the number of array elements from the StringLength parameter to SQLSetStmtAttr, and not from SQL_ATTR_PARAMSET_SIZE.