|Instead of Trigger Error [message #510094]
||Tue, 26 January 2010 09:25
| K Milligan
Registered: January 2010
The following Trigger definition fails when executed as part of an SQL script that's creating DB2 for i database objects.|
CREATE TRIGGER INACTIVATE_EMPLOYEE
INSTEAD OF UPDATE ON ACTIVE_EMPLOYEES
REFERENCING OLD Old_row NEW New_row FOR EACH ROW
INSERT IGNORE INTO inactive_employees (emp_mast_pk)
from emp_mast e
where old_row.empno = e.empno;
The statement fails with an SQL0104 error (Token <end of statement> was not valid.
This SQL statement works fine with other IBM i SQL interfaces.
Powered by FUDForum
. Page generated in 0.02510 seconds