I have written a trigger but to create it by running the sql scripts I get this error DSNT408I SQLCODE = -552, ERROR: TMXS910 DOES NOT HAVE THE PRIVILEGE TO PERFORM

I beleive I need to execute a SET CURRENT SQLID statement.

If I include this statement then I get the error DSNT404I SQLCODE = 098, WARNING: A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOL

Now my sql code looks like :

SET CURRENT SQLID = 'DALLDBA' ;
CREATE TRIGGER TDB2OLTW.CAPS
AFTER UPDATE OF
...
...

The id DALLDBA has proper authority but I cannot logon as DALLDBA. My id is TMXS910

How should I proceed ? any suggestions...

Thanks
Mahendra

If you use SPUFI, you must first change the SQL-delimiter before you execute your SQL-statements. You can change the delimiter by going to the SPUFI default panel.