Informix Error Messages and Error Codes From Error 486 to 494
Informix Error Code -486 Illegal data type found during data conversions.
The data type found in the system descriptor sqlvar entry is either invalid or uninitialized. You cannot use the GET DESCRIPTOR statement to get a value from an uninitialized sqlvar.
Informix Error Code -487 A cursor can only be declared as static or dynamic.
The specified SQL statement requires you to declare a cursor as static or dynamic. Declare the cursor as static or dynamic, depending on which type of cursor is required, and retry the specified operation.
Informix Error Code -488 Invalid operation on cursor.
An invalid operation has been attempted on a cursor. A cursor declared for a SELECT statement cannot be used in a PUT statement. Similarly, a cursor declared for an INSERT statement cannot be used in a FETCH statement. Check the program, and try again.
Informix Error Code -489 Exception number out of bounds.
An exception number was requested that was either less than 1 or greater than the number of diagnostic entries in the diagnostic area.
Informix Error Code -490 Database was created without NLS functionality.
You created a database that lacked NLS functionality.
Informix Error Code -491 DBNLS not set (LC_COLLATE must be string_value).
Set the DBNLS environment variable to an appropriate value. Make sure LC_COLLATE is set to the specified string_value.
Informix Error Code -492 LANG or LC_COLLATE environment variable invalid.
You specified an invalid value for a LANG or LC_COLLATE environment variable.
Informix Error Code -493 DBNLS not set (LC_CTYPE must be string_value).
Set the DBNLS environment variable to an appropriate value. Make sure LC_TYPE is set to the specified string_value.
Informix Error Code -494 LANG or LC_CTYPE environment variable invalid.
You specified an invalid value for a LANG or LC_CTYPE environment variable.
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.
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.