The application allocates a statement handle for the query statement and must set cursor concurrency to allow updates. The default cursor concurrency is SQL_CONCUR_READ_ONLY, which causes the CA IDMS ODBC driver to optimize the calls to the database for retrieval, using BULK FETCH and piggybacked CLOSE options.
The application uses this function to set the SQL_ATTR_CONCURRENCY attribute to SQL_CONCUR_LOCK. This causes the driver to generate calls to the CV that allow the cursor to support positioned updates. If the statement has already been prepared, it is prepared again to use the specified concurrency. If it has already been executed, an error is returned.
|
Copyright © 2009 CA.
All rights reserved.
|
|