Dynamic Column Values in a Query + JDBC Connection

, ,
1

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.

Regards,
kishen Das

2

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

Regards,
Hari

3

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

Kishen Das