db2 trigger syntax

palchuri · #1 (**permalink**) 09-21-05, 14:14

How to handle exception handing in db2 triggers?

ARWinner · #2 (**permalink**) 09-22-05, 07:56

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

palchuri · #3 (**permalink**) 09-24-05, 07:03

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?

skrishnamurthy · #4 (**permalink**) 09-24-05, 19:19

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?

Internet Services

Web Development

Digital Marketing

Consumer Tech