Informix Error Messages and Error Codes From Error 710

SQLServerF1

Informix Error Code -710 Table table-name has been dropped, altered, or renamed.
This error can occur with explicitly prepared statements. These statements have the form:
PREPARE statement id FROM quoted string

After a statement has been prepared in the database server and before the user executes it, the table has been renamed or altered, possibly changing the structure of the table. Problems might occur as a result.
This error can also occur with stored procedures. Before the database server executes a new stored procedure the first time, it optimizes the code (statements) in the stored procedure. Optimization makes the code depend on the structure of the tables that the procedure references. If the table structure changes after the procedure is optimized, but before it is executed, this error can occur.

Each stored procedure is optimized the first time that it is run (not when it is created). This behavior means that a stored procedure might succeed the first time it is run but fail later under virtually identical circumstances. The failure of a stored procedure can also be intermittent because failure during one execution forces an internal warning to reoptimize the procedure before the next execution.
The database server keeps a list of tables that the stored procedure references explicitly. Whenever any of these explicitly referenced tables is modified, the database server reoptimizes the procedure the next time that the procedure is executed.
However, if the stored procedure depends on a table that is referenced only indirectly, the database server cannot detect the need to reoptimize the procedure after that table is changed. For example, a table can be referenced indirectly if the stored procedure invokes a trigger. If a table that is referenced by the trigger (but not directly by the stored procedure) is changed, the database server does not know that it should reoptimize the stored procedure before running it. When the procedure is run after the table has been changed, this error can occur.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *