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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  update sql

    Posted 05/04/08 12:22 PM

    hi to all, i am having a requirement, i am having a table dept and i want to update a value and i am confusing the perameters

    my requirement is

    update dept set dname = ‘willson’ where deptno = 11

    and i am confusing at

    UPDATE TAB

    Expression field : defaultly it is in “?” mark

    WHERE TAB

    Input field :defaultly it is in “?” mark

    Please guide me

    Rgds
    Snigdha


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


  • 2.  RE: update sql

    Posted 05/04/08 03:33 PM

    Is this for a real project? Assuming so, the JDBC Adapter User’s Guide should provide the information you need for the basic operations of the update service template.

    Mark


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


  • 3.  RE: update sql

    Posted 05/05/08 09:35 AM

    See you can change those ‘?’ to your desired one… it means change the 1st field “?” to willson and change the field “?” to 11…


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


  • 4.  RE: update sql

    Posted 05/05/08 02:18 PM

    The “?” means that it will be assigned by an input parameter to the update adapter service. It is up to the user to define the parameter.


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