Informix Error Messages and Error Codes From Error 681 to 686

Informix Error Code -681 Column specified more than once in the INSERT list.
The error occurs if the user specifies a column name more than once in the INSERT column list.
Informix Error Code -682 Error reading constraint index on table table-name.
The system was unable to validate the constraint. See the ISAM error for more information. If this internal error recurs, please note all circumstances and contact Informix Technical Support.

Informix Error Code -683 Specified STEP expression will not traverse RANGE.
The evaluated value of the STEP expression in the FOR statement will lead to an infinite loop.
Example of error:
FOR i = 10 TO 20
STEP -1; — error … END FOR
Correction: Correct either the range or the step expressions so that the incremented values are within the range.
Informix Error Code -684 Function routine-name returns too many values.
The number of returned values from a function is more than the number of values that the caller expects.
Example of error:
CREATE ROUTINE testroutine(arg INT) RETURNING INT, INT;
RETURN 1,2; END ROUTINE
SELECT col FROM tab WHERE col = testroutine(1); — error

Informix Error Code -685 Function function-name returns too few values.
The number of returned values from a function is less than the number of values that the caller expects.
Example of error:
CREATE ROUTINE testroutine (arg INT) RETURNING INT, INT;
RETURN 1,2; END ROUTINE
UPDATE tab SET (c1, c2, c3) = (testroutine(1)); — error
Informix Error Code -686 Function function-name has returned more than one row.
A function returned more than one row of values (for example, it executed RETURN…WITH RESUME) when the caller expected only one row of values.
Example of error:
CREATE ROUTINE testroutine (limit INT) RETURNING INT;
DEFINE i INT; FOR i IN (1 TO limit) RETURN i WITH RESUME; END FOR END ROUTINE;
CREATE ROUTINE gettest() DEFINE var INT;
LET var = testroutine (10); — error END ROUTINE.

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 *