Informix Error Messages and Error Codes From Error 23902 to 23908


Informix Error Code -23902 Operation is not supported in SMI database (%s).
UPDATE STATISTICS cannot be run on the sysmaster database. Check your statement and make sure that the table on which you are running update statistics is not in the sysmaster database.

Informix Error Code -23903 The EXPLAIN output file name must be a NON-NULL CHAR or VARCHAR.
The name given to the EXPLAIN output file is null. Provide a name for the EXPLAIN output file.

Informix Error Code -23904 Attached table (tabname) has an incompatible hash column specification.
The hash column specification of the table named in the error message is not compatible with that of the surviving table or a prior table in the attach list. All tables involved in the attach that have hash-column specifications must have identical hash-column specifications.
Informix Error Code -23905 Attached table (tabname) has an incompatible table type.
The table type (standard, raw, etc.) of each attached table must match that of the surviving table.
Informix Error Code -23908 Alter Fragment option not supported for hash fragmentation.
The surviving table has hash fragmentation and an ALTER FRAGMENT ON TABLE option other than INIT or ATTACH was specified. INIT and ATTACH are the only supported options for hash-fragmented tables.

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 *