By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.