Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Triggers refining a statement
thanks sathyarams, i just tried what you suggested, however it's suggseting a FROM clause is expected, although why i don't know... but at least it's a different error! C:\PROGRA~1\SQLLIB\BIN>db2 -td@ -f G:\Documents\SYS\MB21\Re-assessment\trigger.sql DB21034E The command was processed as an... -
Triggers refining a statement
Thanks for the tip T.Blom but unfortunately that doesn't work, nice idea though. I tried replacing max with line_count in each case, but i got the same error: During SQL processing it returned: SQL0104N An unexpected token "line_count" was found following "MODE DB2SQL... -
Triggers refining a statement
Hi, the error message i get is: SQL0104N An unexpected token "max" was found following "MODE DB2SQL DECLARE". Expected tokens may include: "JOIN <joined_table>". SQLSTATE=42601 I'll also check out that link you provided, Thanks, Jim -
Triggers refining a statement
Hi, I'm having a bit of trouble getting the syntax correct for DB2, please can someone help. :-) Here is the statement i want to add: CREATE TRIGGER archive AFTER INSERT ON order REFERENCING NEW AS new FOR EACH ROW MODE DB2SQL DECLARE max INTEGER; BEGIN SELECT COUNT(*) INTO max FROM...
