467,109 Members | 1,357 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Invoking Stored Procedures in Triggers

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
  • viewed: 1425
2 Replies
Expert 256MB
Hi phanikumarparimi and welcome to TSDB DB2 forum

Moved from Articles

Aug 15 '07 #2
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.

Similar topics

5 posts views Thread by Tim Marshall | last post: by
45 posts views Thread by John | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.