Informix Error Messages and Error Codes From Error 9143 to 9504


Informix Error Code -9143 Character, Text, and Byte data cannot be printed with using formats.
The USING function can only be applied to numeric data. Revise the report specification.
Informix Error Code -9500 A subscript is out of bounds.
This statement takes a substring of a character variable. The substring values (that is, two numbers in square brackets) are incorrect. The first is less than zero or greater than the length of the column, or the second is less than the first. Correct the form specification and recompile.

Informix Error Code -9503 The table tablename could not be opened.
Check that the table name is correctly spelled. If so, the table tablename might not exist in the database (it might have been dropped or renamed); or if it exists, your account might not have SELECT access to it. Alternatively, if you are using the INFORMIX-SE database server, you might have exceeded the limit on open files, which can limit the number of tables that you can name in a SELECT statement. In this case, you might have to revise the SELECT section of the report to use more SELECT statements, each of which names fewer tables. Products after Version 4.0 do not issue this message.

Informix Error Code -9503 PRINT FILE filename could not be opened.
The file that is shown could not be opened for output. Look for operating-system error messages that might give more information. Possible causes include a full disk or lack of the correct permissions for the file or directory.
Informix Error Code -9504 The argument number is out of bounds for the ascii function. Arguments must be between 0 and 255, inclusive.
The input to the ASCII function must be a number between 0 and 255. Examine the use of this function in the report specification. If the improper value number came from a command-line parameter, you might consider testing it with an IF statement.

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 *