Enhanced Support for data-at-exec Feature in Adaptive Server ODBC Driver

In Adaptive Server ODBC Driver version 15.7 ESD #7, the data-at-exec feature has been enhanced to support bulk and batch operations resulting in lower memory utilization and increased performance for applications.

In earlier versions, all of the data for bound parameters had to be fully loaded before calling SQLBulkOperations or executing a batch. In ESD #7, the application does not need to preload any parameter data, it can be sent in chunks using SQLPutData. When using the Adaptive Server ODBC Driver batch protocol (SQLExecute/SQLExecDirect with SQL_ATTR_BATCH_PARAMS), data-at-exec is supported as long as SQL_ATTR_PARAMSET_SIZE is set to 1. Using data-at-exec for LOB columns requires the server to support LOB parameters.