DB2 SQL-Error: -697

Short Description: OLD OR NEW CORRELATION NAMES ARE NOT ALLOWED IN A TRIGGER DEFINED WITH THE FOR EACH STATEMENT CLAUSE OLDTABLE OR NEWTABLE NAMES ARE NOT ALLOWED IN A TRIGGER WITH THE BEFORE CLAUSE C P R FOR EACH ROW

The trigger, as defined, includes a REFERENCING clause with one of the following invalid combinations: v OLD or NEW correlation names specified (or both) and the FOR EACH STATEMENT clause. v NEW_TABLE or OLD_TABLE correlation names specified (or both) and the BEFORE clause.System action: The statement cannot be executed. The trigger was not defined.

 <-  BACK TO INDEX