Great thanks for your help. It worked for some reason. But it's failing on the last sql file. Here's the error message:

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0778N End label "@" is not the same as the begin label. LINE NUMBER=8.
SQLSTATE=428D5

Here is my db2 call: db2 -td@ -f rqprojlock_insert.sql

Here's my sql:

CREATE TRIGGER RQPROJLOCK_INSERT
AFTER INSERT ON RqProjects
REFERENCING NEW AS new_row
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
INSERT INTO RqProjectLocks (ID) VALUES (new_row.ID);
END
@

Thanks again.

That's to be expected: without COMMITs, the CREATEs are rolled back after the last erroneous statement.

Why not just remove the "@" ?
Or remove the "BEGIN ATOMIC" & "END", since it's just a single statement?

The script probably has more than the one statement so the @ terminator is necessary. Yes for this trigger the BEGIN ATOMIC block is unnecessary, but it might be for another trigger. The syntax is correct, so I am guessing that the problem is not related to that. I have seen this error before and I have fixed it by adding "white space". Add a space after the END of the BEGIN ATOMIC and if that does not work, add a space at the end of every line in the trigger.

HTH

Andy

Thanks for all your help. I manually ran the sql in DB2 to create the trigger. Thanks again.

You just need to press ENTER at the end of each delimeter (@) character. Ensure tht here delimiter should always be followed by a carriage return character i.e ENTER"

Thanks and Regards,
GANESH GOSAVI
IBM

Thought I'd post the solution that worked for me, in case it might help someone else.

I, too, was passing an input file. Create failed with the same error (SQL0778N). Resolved it by adding a "begin label" before the BEGIN ATOMIC statement, i.e.

CREATE TRIGGER RQPROJLOCK_INSERT
AFTER INSERT ON RqProjects
REFERENCING NEW AS new_row
FOR EACH ROW MODE DB2SQL
@: BEGIN ATOMIC
INSERT INTO RqProjectLocks (ID) VALUES (new_row.ID);
END
@