Informix Error Messages and Error Codes From Error 9797 to 9802

SQLServerF1

Informix Error Code -9797 User-defined routine language shutdown failed.
The language did not shut down correctly. Probably an internal system error occurred. The following error message appears in the log:
ERROR: error_string Language Shutdown
Informix Error Code -9798 User-defined routine language lookup failed.
Language information is not defined in the system. Either the routine definition is wrong, or something happened to the data dictionary. The following error message appears in the log:
ERROR: Language error_string — lookup failed

Informix Error Code -9799 User-defined routine virtual-processor context-switch failed.
Could not switch to or back from the needed VP during load, unload, or execution. VP class could be wrong in the routine definition. The following error messages appear in the log:
ERROR: Routine execution VP switch failed — new VP error_string
ERROR: Routine execution VP switch failed — old VP id = VP_ID

Informix Error Code -9800 Table table_name is typed.
You cannot add a type to a table that is already typed. Drop the table type and try adding the type again.
Informix Error Code -9801 Cannot alter table table_name to add type. Incompatible.
The column names and the column types of the table do not match the field names and the field types of the type. Change them to statements.
Informix Error Code -9802 Cannot alter typed table table_name.
The only ALTER TABLE statements accepted for a typed table are statements to drop the table type, add a REF column, or drop a REF column. If any other ALTER TABLE statements are needed, first drop the table type.

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 *