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
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
Hi Das, By using the dynamic SQL you can give the column name and its value dynamically at run time.
Regards, Hari
Yeps, thanks for the suggestion. I did the same and its working fine.
Kishen Das