External trigger on DB2 V7.2 for Linux

Hi all, I'm new on DB2 external triggers  and external stored procedures, I have to implement a trigger that calls an external (C++) "program". Im current using DB2 7.2 on a Linux (Suse 9.0). Can anyone give a brief description on how can I implement that and also tell me if I can do that using this plataform I just mentioned ?
Im really  tied to the plataform so please restrict your comments to that. I read some documents about external triggers but Im not sure that it works on V7.1, I also read some paper about  external stored procedures and I think it should also work if I call the external SP from a "normal" trigger. Can anyone adivise me on that ?

Thanks a lot,

Jean Marrara
jmarraraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kent OlsenData Warehouse Architect / DBACommented:

DB2 supports stored procedures in C/C++.  You should be able to write the procedure in C and then tie it to a conventional trigger.  When the trigger fires, execute the C-based stored procedure.


Kent
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.