Informix Error Messages and Error Codes From Error 75 to 101

SQLServerF1

Informix Error Code -75 No message of desired type.
An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -76 Not a data message.
An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -77 Identifier removed.

An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.
Informix Error Code -78 Deadlock situation detected/avoided.
An operating-system error code with the meaning shown was unexpectedly returned to the database server. If the error recurs, please note all circumstances and contact Informix Technical Support.

Under AIX, this code means connection timed out.
Informix Error Code -79 No record locks available.
An operating-system error code with the meaning shown was unexpectedly returned to the database server. This implementation of the Informix database server probably uses kernel locking, the use of the operating-system facilities to lock rows of tables. The capacity of the operating-system lock table has been exceeded. Contact your system administrator and inquire about configuring the operating system to support more locks. Also examine your database application to see if it can use fewer locks by updating fewer rows in each transaction or by locking whole tables instead of rows.
Informix Error Code -100 ISAM error: duplicate value for a record with unique key.
A row that was to be inserted or updated has a key value that already exists in its index. For C-ISAM programs, a duplicate value was presented in the last call to iswrite, isrewrite, isrewcurr, or isaddindex. Review the program logic and the input data. For SQL products, a duplicate key value was used in the last INSERT or UPDATE.
Informix Error Code -101 ISAM error: file is not open.
The ISAM processor has been asked to use an unopened file (table). For C-ISAM programs, the program has tried to use a file before opening it with a call to isopen or has tried to write to a file that was opened in read-only mode. If the error recurs, please refer to the Appendix entitled “Trapping Errors” in your Administrator’s Guide to acquire additional diagnostics. Contact Informix Technical Support with the diagnostic information.

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 *