Informix Error Messages and Error Codes From Error 0 to 1204


Informix error Code 0 Success.
The operation succeeded. The database server returns this
SQLCODE value to an application when an SQL statement
executes successfully.
Informix error Code 100 No matching records found.
The database server did not find any more data. This message is

an ANSI-standard SQLCODE value. If you attempted to select or
fetch data, you encountered the end of the data, or no data
matched the criteria in the WHERE clause. Check for an empty
table. Use this SQLCODE value to determine when a statement
reaches the end of the data. For more information, see the
discussion of SQLCODE in the INFORMIX-ESQL/C Programmer’s
Manual. The database server can return this SQLCODE value to a
running program.

Informix error Code 1203 Cannot find message file.
DataExtract cannot locate a needed message file. Check that you
specified the appropriate pathname when you set the
INFORMIXDIR and DBLANG environment variables. Contact
your system administrator if you need help setting these
environment variables.
Informix error Code 1204 Your system encountered an unknown type of terminal.
Check that you set the TERM environment variable correctly.
Check the database name for correct spelling. Contact your
system adm

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages from Error 0 to 1204 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 *