Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1

    Unanswered: Urgent help needed to Call Stored procedure from DB2 Trigger

    Hi,


    I want to call a stored procedure from a trigger.
    My sql code is like this

    CREATE TRIGGER A.DMS_TEST AFTER INSERT ON B.TDMS_CONFG REFERENCING NEW AS NEWROW FOR EACH ROW MODE DB2SQL BEGIN
    CALL A.P_CONFG(NEWROW.AGNT_CD);
    END

    This code does not compile.Could someone please help on this.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    I don't think you can call a stored procedure from a trigger ...

    Cheers

    Sathyaram

Posting Permissions

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