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.  SQL invoked service

    Posted 06/16/03 04:57 PM

    Hi. I’m pretty new with invoking SQL statements by using the flow service using IS.

    Is there some documentation that i can refer to regarding this?
    I need to send some SQL statements to an SQL server.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: SQL invoked service

    Posted 06/16/03 05:34 PM

    Hi JT,
    See chapter 17 of ISDeveloperGuide.pdf. Go to help –> Developer User Guide.


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 3.  RE: SQL invoked service

    Posted 06/16/03 08:33 PM

    Hi JT,
    Follow this procedure to build a database service.

    1. Define the alias in Server Admin page and test out the connection from webMethods to SQL database.
    2. Use the same alias in execSQL service inside the flow.
    3. Write an SQL and pass this SQL to execSQL service.

    Regards
    RC


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB