ODBC Deferred Array Binding

Adaptive Server Enterprise ODBC Driver now provides the extended SQLBindColumnDA() and SQLBindParameterDA() APIs that allow applications to bind all columns or parameters with a single API call.

When you use these APIs, the pointers to column buffer or parameter buffer are reevaluated for each SQLExecute() or SQLExecDirect() call. Therefore, the application is able to change the buffers without another SQLBindCol() or SQLBindParameter() call. Because the calls to bind new pointers can be expensive, using the new extended APIs improves application performance where the same statement needs to be executed many times. Applications may also be able to save some memory copy operations by changing the buffer pointers before executing a query such that data is read from where available or copied to where needed.

See Adaptive Server Enterprise ODBC Driver by Sybase Users Guide.