Solved

External trigger on DB2 V7.2 for Linux

Posted on 2004-10-29
371 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
Question by:jmarrara
    1 Comment
     
    LVL 45

    Accepted Solution

    by:

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    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…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    934 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now