ODBC Driver Implementation and Configuration › Configure Your ODBC Client › Set the ODBC Client Options › Reduce the Number of Database Calls

Reduce the Number of Database Calls

The statement processing options were implemented to gain performance in web-based applications that typically return a small amount of data. This is accomplished by reducing the number of database calls needed to complete processing in certain circumstances. These options can be modified by the server.

Note: The statement processing options can cause certain features to fail and should be turned on and tested with applications on a case-by-case basis. The failures can occur when statements are related in a non-serial method. The Combine Comit flag can result in invalid cursor status -135 return codes. Turning on these options can also negate cursor behavior other than CLOSE and DELETE.

To reduce the number of database calls

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

   The Statements window appears.

2. Check the following boxes to modify the statement processing options as needed.

   Prepare

   Defers the SQL prepare statement until the SQL execute is issued.

   Execute

   Combines all open database calls up to SQL execute.

   Close

   Combines the close processing with the fetch processing.

   Commit

   Combines the close and commit processing with the fetch processing.

   Faster Execute

   Turns on Defer Prepare, Defer Execute, Combine Close, and Combine Commit.

3. Click OK to finish.

   The CA Datacom/DB ODBC Setup window appears.