Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Unanswered: db2 trigger calling a stored procedure

    The code of my trigger is

    CREATE TRIGGER REORDER
    AFTER UPDATE OF emp_id on emp_master_tb
    REFERENCING NEW AS N
    FOR EACH ROW MODE DB2SQL
    BEGIN ATOMIC
    update desk_master_tb set desk_id =1;
    update desk_emp_link_tb set emp_id= '0';
    insert into test values (1,'2');
    call mstadmin.frm_rpt_utilization();
    END

    But it cannot be created because it is not able to call the stored procedure which is existing in the database. I dont know why . Kindly tell me how I can call stored procedure through a trigger

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Calling Stored Procedures is not supported for DB2 for LUW. I understand that it is for Z/OS.

    Andy

Posting Permissions

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