Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    47

    Unanswered: db2 trigger syntax

    How to handle exception handing in db2 triggers?
    p.srinivasarao

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Please provide you DB2 version and OS.

    For DB2 for LUW, you cannot do that directly in a trigger. With the advent of 8.2, you can call Stored Procedures from triggers which have this capability.

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    47

    Db2 Trigger

    We are using DB2 UDB8.2. What would be the syntax for
    calling stored procedure in db2.

    Can I use same trigger for insert and update?
    p.srinivasarao

  4. #4
    Join Date
    Sep 2005
    Posts
    28

    Wink

    Please follow the link for IBM manuals in PDF format

    http://www-306.ibm.com/software/data...manualsv8.html

    Quote Originally Posted by palchuri
    We are using DB2 UDB8.2. What would be the syntax for
    calling stored procedure in db2.

    Can I use same trigger for insert and update?

Posting Permissions

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