Informix Error Messages and Error Codes From Error 23910 to 23916


Informix Error Code -23910 Result types from case expression must be compatible.
The case expression has a result type that is incompatible with other result types in this expression. Only one type can be returned in a case expression. Review the data types in your case expression and make sure that only compatible result types are returned.

Informix Error Code -23913 SAMPLE/LOCAL specifiers apply to tables. table_name is not a table.
The select statement includes a SAMPLE or LOCAL keyword, but the table_name specified in the FROM clause is not a database table. Check to see that the tables specified by the SAMPLE or LOCAL keyword in the FROM clause are not VIEWS or EXTERNAL TABLES.

Informix Error Code -23914 Operation not supported on secondary coservers.
DDL (Data Definition Language) Statements (such as CREATE VIEW) are not supported while connected to a secondary coservers.
Reconnect to coserver 1 and execute the DDL statement.
Informix Error Code -23915 Alter Fragment option not supported for hybrid fragmentation.
The surviving table has hybrid fragmentation and an ALTER FRAGMENT ON TABLE option other than INIT, ATTACH, or DETACH was specified. INIT, ATTACH, and DETACH are the only supported options for hybrid-fragmented tables.
Informix Error Code -23916 Attached table (tabname) has an incompatible fragmentation scheme.
The fragmentation scheme of the table named in the error message is not a kind that can be attached to the surviving table in the ALTER FRAGMENT ON TABLE command.

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 *