Invoking Stored Procedures in Triggers

phanikumarparimi

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

Purple

Hi phanikumarparimi and welcome to TSDB DB2 forum

Moved from Articles

Moderator

Aug 15 '07 #2

rdpratti

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