Informix Error Messages and Error Codes From Error 693 to 697

SQLServerF1

Informix Error Code -693 System command expects a non-null value.
A null value was passed to the SYSTEM statement.
Example of error:
DEFINE c CHAR(100);
LET c = NULL; … SYSTEM c; — error

Informix Error Code -694 Too many arguments passed to procedure procedure-name.
More arguments were passed to a procedure than a procedure was declared to accept.
Informix Error Code -695 Argument is not a parameter of procedure procedure-name.
A named parameter was passed to a procedure, but the named parameter does not exist.
Example of error:
CREATE PROCEDURE testproc (arg1 INT, arg2 INT) RETURNING INT; …
RETURN 1; END PROCEDURE
SELECT col FROM tab WHERE testproc (arg1 = 10, arg5 = 20); — error

Informix Error Code -696 Variable variable-name has undefined value.
A variable was used that was never assigned a value.
Example of error:
DEFINE i, j INT; LET i = j + 1; — error
Correction: Assign all variables and parameters a legal value before you use them.
Informix Error Code -697 STEP expression evaluated to ZERO.
The STEP expression of a FOR statement evaluated to zero.
Example of error:
LET e = -1; FOR i = 10 TO 20
STEP e+1; — error … END FOR
Correction: Change the STEP expression so that it evaluates to a nonzero value.

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 *