Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    10

    Unanswered: trigger & SQL procedure

    Is it possible to call SQL procedure from trigger?
    If yes how? I tried it, but I was not succesfull, I got SQLSTATE=42884.
    In message was, that I need to call a function.

    Thanks for answer.

    Rene

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Not possible if you are using DB2 on Windows or Unix (It should be possible with Stinger)

    DB2 for zOS allows

    Cheers
    sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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