ODBC Driver Implementation and Configuration › Configure Your ODBC Client › Set the ODBC Client Options › Define Auto Commit

Define Auto Commit

You can set auto commit for the ODBC data source and perform table/view list caching when you choose the Miscellaneous button.

To define auto commit

1. Select the Misc button on the Options tab of the CA Datacom/DB ODBC Setup window.

   The Miscellaneous dialog appears.

2. Select the Auto Commit box to enable the auto commit mode for the data source.

   Note: In auto commit mode, every database update is a transaction that is committed when performed. In manual commit mode, applications must explicitly complete transactions by calling SQLEndTran to commit or rollback. The default is auto commit.

3. Select the Table Caching box to specify whether the server is to perform table/view list caching.

   Note: With caching enabled, a table/view selection list from the mainframe dataset is stored locally on the PC for the duration of the connection. This allows the server to redisplay the table/view selection list quickly since it does not have to retrieve the list from the mainframe.

4. Click OK.

   The CA Datacom/DB ODBC Setup window appears.