Informix Error Messages and Error Codes From Error 719 to 725


Informix Error Code -719 Loop variable variable-name cannot be declared GLOBAL.
A global variable cannot be used as a loop variable. Redefine the variable to be local to the loop, or use another (local) variable as the loop variable.
Informix Error Code -720 Number of columns in FOREACH SELECT does not match number of variables.
A mismatch exists in the number of columns the SELECT returns and the number of variables that are specified in the INTO list. Correct the number of variables in the INTO list.

Informix Error Code -721 Stored procedure procedure-name is no longer valid.
You are attempting to execute a procedure from an EXECUTE statement, but it has been redefined since the PREPARE statement was run. You must use the PREPARE statement again on the EXECUTE PROCEDURE statement.
For example, the following sequence of code would cause this error:
$prepare pr_stat from ‘execute procedure testproc()’; …
/ drop procedure testproc create procedure testproc() …… [same application or different] */ … $execute pr_stat;/* triggers error -721 */
Informix Error Code-722 Out of stack space.
The database server has run out of memory for stack space. Ask the Informix database administrator to increase the STACKSIZE parameter that is specified in the $ONCONFIG (or $TBCONFIG) file to allocate more memory. The database server must be restarted for the change to take effect.

Informix Error Code -723 Cannot disable logging in an ANSI-compliant database.
You attempted to use the START DATABASE WITH NO LOG syntax to remove database logging on an SE database that is ANSI compliant. You cannot turn off logging by running this statement on this kind of database.
Informix Error Code -724 System initialization file $INFORMIXDIR/cnv50t60.sql is missing.
Check that $INFORMIXDIR/cnv50t60.sql is in place and readable. If it is, and the system still fails, reinstall the system.
Informix Error Code -725 Error occurred while reading system initialization file $INFORMIXDIR/cnv50t60.sql.
Check that the script file $INFORMIXDIR/cnv50t60.sql is readable. If it is, and the failure still occurs, reinstall the product.

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 *