Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > OPEN >

3DDL Operations on Tables Referenced by Cursors

3 3

Various DDL statements can drop, rename, or alter the schema of a table 3that is referenced directly (or indirectly, by the identifier of a prepared 3statement) in the DECLARE statement that defines a cursor. Subsequent OPEN 3operations on the cursor might fail with error -710, or might produce unexpected 3results.

3

Adding an index to a table that is referenced directly or indirectly in 3a DECLARE statement can similarly invalidate the associated cursor. Subsequent 3OPEN statements that specify the invalid cursor fail, even if they include 3the WITH REOPTIMIZATION keywords. If an index is added to the table that is 3associated with a cursor, you must prepare the statement again and declare 3the cursor again before you can open the cursor. You cannot simply reopen 3a cursor that is based on a prepared statement that is no longer valid.

Related Information

Related statements: ALLOCATE DESCRIPTOR, DEALLOCATE DESCRIPTOR, DESCRIBE, CLOSE , DECLARE , EXECUTE , FETCH , FLUSH , FREE , GET DESCRIPTOR , PREPARE, PUT , SET AUTOFREE, SET DEFERRED_PREPARE, and SET DESCRIPTOR

For a task-oriented discussion of the OPEN statement, see the IBM Informix Guide to SQL: Tutorial.

For more information on system-descriptor areas and the sqlda structure, refer to the IBM Informix ESQL/C Programmer's Manual.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]