Cursor Behavior

Silk Performer queries the cursor behavior of the DBMS to which it is connected, in order to be able to decide whether the SQL statement has to be prepared before it can be executed.

• SQL_CURSOR_COMMIT_BEHAVIOR indicates how a commit operation affects cursors and prepared statements.
• SQL_CURSOR_ROLLBACK_BEHAVIOR indicates how a rollback operation affects cursors and prepared statements.
• SQL_CB_DELETE (0) indicates that the DBMS closes cursors and deletes prepared SQL statements. To use the cursor again, the application must reprepare and re-execute the SQL statement.
• SQL_CB_CLOSE (1) indicates that the DBMS closes cursors. For prepared SQL statements, the application can execute the SQL statement without repreparing it.
• SQL_CB_PRESERVE (2) indicates that the DBMS preserves cursors. The application can continue to fetch data or it can close the cursor and reexecute the SQL statement without re-preparing it.

For a detailed description of SQL_CURSOR_COMMIT_BEHAVIOUR and SQL_CURSOR_ROLLBACK_BEHAVIOUR, see your ODBC documentation.