[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

External trigger on DB2 V7.2 for Linux

Posted on 2004-10-29
1
Medium Priority
?
426 Views
Last Modified: 2009-12-16
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
0
Comment
Question by:jmarrara
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 46

Accepted Solution

by:
Kent Olsen earned 1500 total points
ID: 12463088

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question