Informix Error Messages and Error Codes From Error 291 to 297


Informix Error Code -291 Cannot change lock mode of table.
The current LOCK TABLE statement cannot be executed because you have already locked the same table using a different mode (EXCLUSIVE or SHARE). To change the lock mode, arrange to unlock the table before you lock it again.
Informix Error Code -292 An implied insert column column-name does not accept NULLs.
This INSERT statement does not supply values for all the columns in the table. At least one of the columns that it omits is constrained to be not null. Since the database server would have to insert a null value for every unmentioned column, it cannot perform this insert. Review the statement against the definition of the table. Possibly the definition of the table has been changed.

Informix Error Code -293 IS [NOT] NULL predicate may be used only with simple columns.
The test for a null value can be applied only to a column name (not to a subscripted character column or an expression, for example). Review the use of these keywords in the WHERE clause.
Informix Error Code -294 The column column-name must be in the GROUP BY list.
In a grouping SELECT, you must list every nonaggregate column in the GROUP BY clause to ensure that a well-defined value exists for each selected column in each grouped row. A column contains either a single aggregate value or a value unique to that group. If a selected column were neither an aggregate nor in the list, two or more values for that column might possibly exist in some group, and the database server could not choose which to display. Revise the query to include either the column name or its positional number in the clause.

Informix Error Code -295 Referenced and referencing tables have to be in the same database.
Referential constraints cannot cross databases. In other words, both the referenced and referencing columns (or parent and child keys) must be in the same database.
Informix Error Code -296 Referenced table table-name not found.
The table that is specified in a referential constraint does not exist.
Informix Error Code -297 Cannot find unique constraint or primary key on referenced table table-name.
The database server cannot locate the referenced constraint in the sysconstraints system catalog table, and the referenced constraint was not created in the same ALTER TABLE statement as the referencing constraint. The referenced constraint might not exist. Check that you have entered a valid column name with the appropriate constraints that are associated with it. Valid constraint columns indicate an internal error. If the error recurs, please note all circumstances and contact Informix Technical Support.

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 *