Tag: DB2 Error Messages

IBM DB2 Error Code -697 – old or new correlation names are not all

In this post, you’ll learn about the IBM DB2 Error -697 and the reason why you are receiving it IBM DB2 Error Code : -697 Reason for this Error in DB2 OLD OR NEW CORRELATION NAMES ARE NOT ALLOWED IN A TRIGGER DEFINED WITH THE FOR EACH STATEMENT CLAUSE. OLD_TABLE OR NEW_TABLE NAMES ARE NOT ALLOWED IN A TRIGGER WITH THE BEFORE CLAUSE.