The application uses SQLExecute to cause the driver to EXECUTE the statement or OPEN the cursor for a query. If the statement has not been PREPAREd yet, or a parameter has been changed for r12.0, the driver must PREPARE the statement first. If the statement is a query, the driver may piggyback an OPEN on this PREPARE converse.
For r14.0 or later, the application can change the contents of bound parameter buffers and re-execute the prepared statement repeatedly without requiring the driver to PREPARE the statement again.
CA IDMS discards all prepared statements when the transaction is committed. When auto commit is enabled, statements must be prepared each time they are executed. The driver does this transparently by caching the SQL syntax. An application can avoid this by disabling auto commit or setting the commit behavior to SQL_CB_PRESERVE, as described for the ODBC Positioned Updates feature.
|
Copyright © 2009 CA.
All rights reserved.
|
|