Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Unanswered: Calling COBOL Subroutine from DB2 Trigger

    Hi ,

    I have a need to procees some task based on insertion/updation of a table.
    For this I am planning to create a trigger which will tell me when there is any action(insert/update) on this table.

    Now I need the way to call a cobol sub-routine from the trigger action part.
    In COBOL sub-routine I need to validate the data in DB2, create XML and this XML I have to keep in the MQ.


    Could any one please suggest me on this ?


    Thanks in Advance,
    Vijay.

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    You can write a UDF or stored procedure and call that from the trigger body.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Mar 2009
    Posts
    3
    Thanks Stolze. Could you please post a sample one for calling cobol sub-routine from a DB2 SP ??


    Cheers
    Vijay.

  4. #4
    Join Date
    Mar 2009
    Posts
    3
    Sorry Stolze. Is COBOL SP or DB2 SP can be called from DB2 trigger ?

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    In DB2/LUW: Yes
    In DB2/z: dunno

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •