IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

JDBC adapter with DB2/400 triggers?

  • 1.  JDBC adapter with DB2/400 triggers?

    Posted Wed June 19, 2002 04:19 PM

    Hello,
    We are trying to setup an update notification on a DB2 table/file on our AS/400.
    My question, when we enable the integration component, will it add to an existing update trigger on the file or overwrite the file?

    Please HELP !!!


    #Integration-Server-and-ESB
    #Adapters-and-E-Standards
    #webMethods


  • 2.  RE: JDBC adapter with DB2/400 triggers?

    Posted Wed July 03, 2002 11:19 AM

    Currently DB2 only allows for 6 triggers. One for each event Before/After on Update/Delete/Insert events.

    If you have a trigger and you wish to add another for the same event you will most likely have to re-program the trigger code to include the logic for both triggers. You can then recompile the trigger. Of course you will have to use Basic Notification and that means creating the shadow tables manually. The whole process is fairly simple.

    Hope this helps.

    CD


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


Related Content