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.  Dynamic SQL query

    Posted Mon March 04, 2013 07:18 AM

    Hi,
    I need to execute a query with n number of condition. I don’t know the number of conditions that will be set.
    I read that i can create a Dynamic SQL. Can you show me an example?

    Thanks,
    Regards
    Fabio


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


  • 2.  RE: Dynamic SQL query

    Posted Mon March 04, 2013 01:46 PM

    Please refer to page number 112 in the JDBC adapter user’s guide ([url]http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/adapters_estandards/Adapters/JDBC/JDBC_6-0-3/JDBC%20Adapter%206.0.3/webMethods%20JDBC%20Adapter%20User’s%20Guide%206.0.3.pdf[/url]). It has a simple query implemented using Dynamic SQL adapter template.


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


Related Content