Informix Error Messages and Error Codes From Error 731 to 735

SQLServerF1

Informix Error Code -731 Invalid use of column reference in trigger body.
For insert and delete triggers, the offending column is being used in the INTO clause of the EXECUTE PROCEDURE statement (which is only allowed for an update trigger). Remove the column names from the INTO clause.
Informix Error Code -732 Incorrect use of old or new values correlation name inside trigger.
You cannot use the new or old correlation name outside the FOR EACH ROW section or in the INTO clause of the EXECUTE PROCEDURE statement. You cannot use the new or old correlation name to qualify the SELECT COUNT DISTINCT column. For example, the following statement returns this error:

SELECT COUNT (DISTINCT oldname.colname)
You cannot specify an old correlation name for an insert trigger. You cannot specify a new correlation name for a delete trigger.
Informix Error Code -733 Cannot reference procedure variable in CREATE TRIGGER or CREATE VIEW statement.
You have a CREATE TRIGGER or CREATE VIEW statement inside a stored procedure, and within the CREATE TRIGGER or CREATE VIEW statement, you reference a variable that is defined in the stored procedure. This action is not legal. Remove the reference to the stored procedure variable from the CREATE TRIGGER or CREATE VIEW statement and try again.

Informix Error Code -734 Object name matches old or new values correlation name.
This error is returned in three cases:
The name of the triggering table or the synonym, if it is used, matches the old or new correlation name in the REFERENCING clause.
The name of a table or a synonym that is referenced in the action clause matches either the old or new correlation name in the REFERENCING clause.
The old correlation name matches the new correlation name.
Change either the correlation name or the table name, and execute the CREATE TRIGGER statement again.
Informix Error Code -735 Cannot reference table that participates in cascaded delete.
If a child table is referenced in a correlated subquery that is part of a DELETE statement, the child table cannot be one of the tables on which a delete would cascade. This action is not allowed because the result depends on the order in which the rows are processed. Rewrite your query so that the child table is not referenced in a correlated subquery.

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.

Thanks,
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 *