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.

Invoking Stored Procedures in Triggers

P: 2
Hi all ,
I need to write a stored procedure which will be called when an after insert trigger fires.The Parameters for the SP called would be transition tables.Can anyone help me out in how to define transition tables as parameters in the stored Procedure and how to use them in the Body of the Stored Procedure.I am using Db2 v8 on Z/OS. Any help in the form of sample code or suggestions would be greatly appreciated.The language used id SQl

Thanks in Advance
Phani Kumar PV
Jul 22 '07 #1
Share this Question
Share on Google+
2 Replies


Purple
Expert 100+
P: 404
Hi phanikumarparimi and welcome to TSDB DB2 forum

Moved from Articles

Moderator
Aug 15 '07 #2

P: 1
I am trying to determine the same thing for the Windows version of the product.
I have seen articles out there that state that you can actually access the transition trables from within the store procedure with SQL.
Do a google on "transition tables" "stored procedure" DB2 and should find them.
Good luck.

- rd
Nov 17 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.