Informix Error Messages and Error Codes From Error 659 to 663

SQLServerF1

Informix Error Code Informix Error Code -659 INTO TEMP table required for SELECT statement.
A SELECT statement did not specify where to put the returned values. SELECT statements within a procedure require either an INTO TEMP clause or an INTO clause that references the appropriate procedural variables.
Example of error:
CREATE PROCEDURE testproc() …
SELECT col1, col2 FROM tab; — error END PROCEDURE
Correction:
CREATE PROCEDURE testproc() …
SELECT col1, col2 INTO var1, var2 FROM tab; SELECT col1, col2 FROM tab INTO TEMP another_table; END PROCEDURE

Informix Error Code Informix Error Code -660 Loop variable variable-name cannot be modified.
An attempt was made to modify the value of a loop variable in a FOR statement. Loop variables cannot be modified inside a loop.
Example of error:
FOR i IN (1,2,3,4)
LET i = i + 1; — error END FOR
Correction: Use another variable in the LET statement.
Informix Error Code Informix Error Code -661 Number of variables does not match number of values returned.
The number of variables on the left side of a LET statement does not match the number of values on the right side.
Example of error:
LET a,b = 10,20,39; LET i,j = proc1()+proc2(); LET a,b = (SELECT c1 FROM tab)
Correction: Match the number of expressions on both sides of the LET statement.

Informix Error Code Informix Error Code -662 Loop variable variable-name specified more than once.
A loop variable was used more than once in a FOREACH statement.
Example of error:
FOREACH SELECT col1, col2 INTO var, var FROM tab — error …
END FOREACH
Correction:
FOREACH SELECT col1, col2 INTO var1, var2 FROM tab …
END FOREACH
Informix Error Code Informix Error Code -663 You are using more than one procedure-calling syntax for procedure procedure-name.
While calling a procedure, some of the arguments were named, but others were not.
Example of error:
LET var = proc (arg1 = 10, 20, arg3 = 30); — error
Correction:
LET var = proc (arg1 = 10, arg2 = 20, arg3 = 30); –correct LET var = proc (10,20,30);–correct.

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 *