SQL_ATTR_BATCH_PARAMS, a Sybase-specific connection attribute, has been introduced to manage the batches of parameters sent to Adaptive Server. Set SQL_ATTR_BATCH_PARAMS using SQLSetConnectAttr.
SQL_BATCH_ENABLED – informs Adaptive Server Enterprise ODBC Driver to batch the parameters. When in this state, the driver sends an error if a statement other than the statement being processed—the first statement executed after setting SQL_ATTR_BATCH_PARAMS to SQL_BATCH_ENABLED—by SQLExecute is executed on the connection.
SQL_BATCH_LAST_DATA – specifies that the next batch of parameters is the last batch, and that the parameters contain data.
SQL_BATCH_LAST_NO_DATA – specifies that the next batch of parameters is the last batch, and to ignore the parameters.
SQL_BATCH_CANCEL – informs the Adaptive Server Enterprise ODBC Driver to cancel the batch and to roll back the transactions.
Only uncommitted transactions can be rolled back.
SQL_BATCH_DISABLED – (default value) Adaptive Server Enterprise ODBC Driver returns to this state after processing the last batch of parameters. You cannot manually set SQL_ATTR_BATCH_PARAMS to this value.