467,199 Members | 987 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

Calling a stored procedure from a trigger in DB2 V7.2 FP10

Hi,

Is ti possible to call a stored procedure from a trigger in DB2UDB V7.2
FP10?
If not, is there a Fix Pack that allows it? Do I have to change the version
of my UDB?
Thanks
Vince
Nov 12 '05 #1
  • viewed: 3994
Share:
1 Reply
Vince wrote:
Hi,

Is ti possible to call a stored procedure from a trigger in DB2UDB V7.2
FP10?
If not, is there a Fix Pack that allows it? Do I have to change the
version of my UDB?


DB2 V8.2 (aka V8.1 + FP7) is the first version that supports the CALL
statement in triggers natively.

As a work-around on V7, you could follow the steps outlined here:
http://www.ibm.com/developerworks/db...ein/index.html

p.s: V7 is out of service since last week. So you might consider upgrading
in any case...

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Paul Reddin | last post: by
2 posts views Thread by Prem via DBMonster.com | last post: by
5 posts views Thread by wpellett@prodigy.net | last post: by
4 posts views Thread by Pakna | last post: by
3 posts views Thread by yinzara@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.