Informix Error Messages and Error Codes From Error 653 to 658


Informix Error Code -653 Variables declared as LIKE cannot be global.
A global variable was defined as LIKE. LIKE variables must be local variables.
An example of the error follows:
DEFINE GLOBAL var LIKE tab.col; — error
Correction: Do not use the LIKE keyword with global variables. Instead, specify the data type explicitly.

Informix Error Code -654 Bad use of PROCEDURE declaration type.
The procedure declaration was used either in the parameters or the RETURNING clause. Stored procedures cannot accept or return procedures.
An example of the error follows:
CREATE PROCEDURE testproc (proc1 procedure) — error
RETURNING procedure; — error … END PROCEDURE
Correction: Do not attempt to use the procedure declaration type within a parameter or the RETURNING clause.
Informix Error Code -655 RETURN value count does not match procedure declaration.
The number of values that a procedure was declared to return in the RETURNING clause does not match the number of values in a RETURN clause.
An example of the error follows:
RETURN 1,2,3; — error … RETURN 1; — error END PROCEDURE
Correction: In this example, return exactly two arguments.

Informix Error Code -656 Routine is not declared to return values.
When the routine was declared, it did not contain a RETURNING clause to indicate that the routine would not return any value, but then a RETURN statement was found in the body of the routine.
An example of the error follows:
LET a = 10; RETURN a + 1; — error END ROUTINE
Correction: Add a RETURNING clause before the DEFINE statement, or remove the RETURN statement.
Informix Error Code -657 Cannot create a procedure within a procedure.
You cannot have a CREATE PROCEDURE statement within a CREATE PROCEDURE statement.

Informix Error Code -658 Variables declared as GLOBAL require a default value.
A global variable was not given a default value. Global variables require a default value.
Example of error:
DEFINE GLOBAL glob INT; — error

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.

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 *