Informix Error Messages and Error Codes From Error 687 to 692

SQLServerF1

Informix Error Code 687 Set debug file before tracing stored procedures.
A TRACE statement (except TRACE OFF) was executed before a SET DEBUG FILE statement. It is unknown where the output of the TRACE statement would go.
Example of error:
TRACE procedure; — error
Correction:
SET DEBUG FILE TO ‘trace.out’; TRACE procedure;

Informix Error Code -688 Variable variable-name must be declared CHAR or VARCHAR.
You declared the variable as a data type other than CHAR or VARCHAR. Correct the declaration, and try again.
Informix Error Code -689 Global variable variable-name declared inconsistently.
Two or more procedures were executed that defined the same global variable with different data types.
Example of error:
CREATE PROCEDURE test1()
DEFINE GLOBAL glob INT DEFAULT 10; … END PROCEDURE
CREATE PROCEDURE test2()
DEFINE GLOBAL glob CHAR (9) DEFAULT USER; … END PROCEDURE
Correction: Declare global variables consistently. (Using appropriate naming conventions would be useful.) Two variables of the same data type but different lengths are considered inconsistent.

Informix Error Code -690 Cannot read keys from referencing table table-name.
The referential constraint could not be validated. See the ISAM error for more information. If you are using cascading deletes, database logging must be on.
Informix Error Code -691 Missing key in referenced table for referential constraint constraint-name.
A referential constraint has been violated. This condition usually occurs when you are trying to insert a value into or update the value of a column that is part of a referential constraint. The value you are trying to enter does not exist in the referenced (parent-key) column(s). If you are using cascading deletes, database logging must be on.
Informix Error Code -692 Key value for constraint constraint-name is still being referenced.
You have violated a referential constraint. This situation usually occurs when you are trying to delete a row in a column (parent key) that another row (child key) is referencing. If you are using cascading deletes, database logging must be on.

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 *