Dynamic Column Values in a Query + JDBC Connection

Dear All,

Can we achieve something like this ?
“select * from tableName where ? = ?”. Here both column name and its value has to be dymanic and I should be able to pass/map these values from the pipeline. Is there a customized SQL in webMethods using which I can achieve this?

Also is there any API ( that can be called inside a Java Service) to get the handle to a JDBC Connection.

kishen Das

Hi Das,
By using the dynamic SQL you can give the column name and its value dynamically at run time.


Yeps, thanks for the suggestion. I did the same and its working fine.

Kishen Das