Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    48

    Wink Unanswered: How to create triggers on DB2 OS390 foreground

    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

  2. #2
    Join Date
    Nov 2003
    Location
    Germany
    Posts
    62
    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.

  3. #3
    Join Date
    Apr 2004
    Posts
    48

    Great !!! It works. Thanks

    Originally posted by Walter Janissen
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •