Informix Error Messages and Error Codes From Error 23918 to 23923


Informix Error Code -23918 Cannot create detached cluster index.
Fragmentation scheme cannot be specified when creating cluster index.
Informix Error Code -23920 Could not create bitmap index due to outstanding in-place alter.
A create index using bitmap statement was specified on a table that has outstanding in-place alters. The in-place alter must complete before such an index can be created. A dummy update of the entire table will cause the in-place alter to complete.

An example of a dummy update is an update that changes all the rows in the table and specifies that a column be set to itself.
Informix Error Code -23921 Cannot alter table type in combination with other alter table options.
You must use separate statements to alter the table type with an ALTER TABLE statement. It cannot be done in combination with other ALTER TABLE options.

Informix Error Code -23922 Serial column usage incompatible with fragmentation scheme.
A table can be fragmented on a serial column only if the table is fragmented by hash and the serial column is the only column in the key. Tables fragmented by expression or hybrid that use serial columns in the fragmentation are not valid. Neither are hash-fragmented tables that have any columns in addition to the serial column used for fragmentation.
Informix Error Code -23923 HAVING clause should be accompanied by a GROUP clause or with aggregates on all columns in the SELECT clause.
The HAVING clause in a query should be accompanied either by a GROUP BY clause or it should be accompanied by a SELECT clause containing only AGGREGATES on columns or column-expressions. The HAVING clause is used to apply filter expressions on a “grouped” result. A grouped result is obtained either by using a GROUP BY clause or by using only AGGREGATES in the SELECT clause. In the latter case, the result involves only one group and the result contains only one aggregated row.

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 *