Various DDL statements can drop, rename, or alter the schema of a table 3that a prepared object references, but subsequent attempts to execute the 3prepared object might fail with error -710, or might produce unexpected results.
3Adding an index to a table that a prepared statement references can similarly 3invalidate the prepared statement. A subsequent OPEN statement fails if the 3cursor refers to the invalid prepared statement, even if the OPEN statement 3includes the WITH REOPTIMIZATION keywords. If an index is added after the 3statement was prepared, you must prepare the statement again and declare the 3cursor again. You cannot simply reopen the cursor if it is based on a prepared 3statement that is no longer valid.
Related statements: CLOSE , DECLARE , DESCRIBE, EXECUTE , FREE , OPEN , SET AUTOFREE, and SET DEFERRED_PREPARE
For information about basic concepts that relate to the PREPARE statement, see the IBM Informix Guide to SQL: Tutorial.
For information about more advanced concepts that relate to the PREPARE statement, see the IBM Informix ESQL/C Programmer's Manual.