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

Define the Behavior

You can change the access mode, the transaction level, and the cursor behavior when you select the Behaviors button.

Important! Value comparisons in SQL such as greater than and less than are passed to the mainframe and are executed there using EBCDIC collating sequence.

To define behavior when accessing data

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

   The Cursor Behavior and Access Mode dialog appears.

2. Select READ ONLY or READ/WRITE from the drop-down list in the Access Mode field.
3. Select CLOSE AND DELETE CURSORS, CLOSE CURSORS, or CLOSE AND PRESERVE CURSORS from the drop-down menu in the Commit Behavior field.

   Note: Specifying CLOSE or PRESERVE cursors can adversely affect performance by reducing the amount of blocked data that can be transmitted.

4. Select CLOSE AND DELETE CURSORS, CLOSE CURSORS, or CLOSE AND PRESERVE CURSORS from the drop-down menu in the RollBack Behavior field.
5. Click OK to finish.

   The CA Datacom/DB ODBC Setup screen appears.