SQL Statements › OPEN › Effect of Temporary Tables

Effect of Temporary Tables

In some cases, CA Datacom/DB derives the result table of a cursor by first creating a temporary table when the OPEN statement is executed. When a temporary table is used, the results of a program can differ in two ways:

1. An error can occur during OPEN that would otherwise not occur until some later FETCH statement.
2. If you selected cursor stability as your isolation level, INSERT, UPDATE, and DELETE statements executed by other transactions while the cursor is open do not affect the result table.