Informix Error Messages and Error Codes From Error 630 to 636


Informix Error Code -631 Cannot create optical cluster on column that is not TEXT or BYTE.
You can only create optical clusters on columns of TEXT or BYTE data type. The column name is some other type. Check that the column is the one you meant to specify, and review the definition of the table.
Informix Error Code -632 Cannot create optical cluster.
An attempt to create an optical cluster has failed. See the ISAM error for more information.
Informix Error Code -633 Cannot drop optical cluster.
An attempt to drop an optical cluster has failed. See the ISAM error for more information.

Informix Error Code -634 Object does not exist.
You are trying to drop a trigger that does not exist. Check that you are spelling the name of the trigger correctly. Also, you might query the systriggers system catalog table to review the names of triggers in the database.
Informix Error Code -635 Not owner of object.
You are trying to drop a database object that you do not own. You might query the appropriate system catalog table to see who owns the object. (For example, for a trigger, query the systriggers table.) You probably need to ask the owner of the database object or the database administrator to drop the object.

Informix Error Code -636 Total size of key fields is too large or there are too many key fields.
You have violated one of the following constraints on the cluster key that is specified in the ON clause of the CREATE OPTICAL CLUSTER statement:
The number of columns included in a composite cluster key exceeds 16.
The length of a CHARACTER column exceeds 256 bytes.

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 *