The default behavior for ODBC is to execute a COMMIT after each statement. The default behavior for CA IDMS is to close any open cursors when a transaction is committed, which would allow only a single positioned update for a cursor. To avoid this, the application must disable the automatic commit or change the CA IDMS commit behavior.
The application uses this function to get SQL_CURSOR_COMMIT_BEHAVIOR. If the value is not SQL_CB_PRESERVE, the application should disable AutoCommit.
The application uses this function to disable the SQL_AUTOCOMMIT option.
If the application does not disable the AutoCommit option at runtime, use the CA IDMS ODBC Administrator to set the COMMIT BEHAVIOR option to PRESERVE CURSORS. This causes the ODBC driver to issue a COMMIT CONTINUE when committing a transaction, which preserves cursor currency.
|
Copyright © 2009 CA.
All rights reserved.
|
|