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
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.