Informix Error Messages and Error Codes From Error 971 to 974


Informix Error Code -971 Integrity violations detected.
The user has attempted to change the object mode of a disabled constraint or disabled unique index to the enabled or filtering mode, but the SET statement fails because the table contains data that violates the constraint or the unique-index requirement. If a violations table has been started for the table that contains the inconsistent data, this message is returned to the user. The message is returned whether or not the SET statement included the WITH ERROR option.

Similarly, when an INSERT, DELETE, or UPDATE statement causes some records to be added to the violations table because the statement violates a filtering-mode object, this message is returned to the user if the following two conditions are true:
The SET statement or CREATE statement that specified the filtering-object mode for the object included the WITH ERROR option.
No other errors have been encountered during the execution of the INSERT, DELETE, or UPDATE statement.
Informix Error Code -972 Unable to alter table table-name.
The in-place alter table operation cannot be performed. Please see the accompanying ISAM error for more information.

Informix Error Code -973 Cannot insert from the violations table to the target table.
The user issued a statement that attempts to insert rows from the violations table into the target table. For example, the user enters the following statement:
INSERT INTO mytable SELECT * FROM mytable_vio
If the target table has some filtering-mode objects, this error is returned to the user. The user can recover in any of the following ways:
Set the object mode of the filtering objects to some other mode.
Stop the violations table.
Insert rows from the violations table into a temporary table, and then insert rows from the temporary table into the target table.
Informix Error Code -974 Cannot drop not null constraint on the serial column.
The user issued a statement to drop a NOT NULL constraint on a column that has a SERIAL data type. Such constraints can be disabled, but they cannot be dropped before the column is dropped.

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 *