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.

 View Only
  • 1.  Notifier Update Operation

    Posted Fri May 23, 2003 10:21 AM

    Hi,
    I am working on Enterprise Integrator 4.5.2, ODBC Adapter 4.1.1

    I created a Notifier Update Configured Operation and a respective Update Configured Operation that talks with MS SQL 2000 server.

    In Notifier Update Configured Operation, I have selected to return all the columns of a table on updating a record.

    In My Update Configured Operation, I am updating the some columns of a table including primary key column value. Its like this SQL statement.

    Update <table> set column1=‘aa’,column2=‘bb’,pk_column=‘value2’ where
    pk_column=‘value1’.

    When a row gets updated, the Notifier will get triggered and will return the new updated row (aa,bb and value2) that is visible when I run the ODBC Adapter in debug mode in Adapter Configuration.

    Now how Can I get the old value of pk_column ‘value1’ from the Notifier, so that I can map to the “where clause” of the Update Configured Operation.

    Any tips would be highly appreciated.


    #Integration-Server-and-ESB
    #Universal-Messaging-Broker
    #broker
    #webMethods