i am making an UPDATESQL in webMethods 6.5.
IF i hardcode the value in the UpdateSQL, it works fine.
when i try to pass 2 variables in the UpdateSQL, nothing happens in the database, no update.
My SQL : UPDATE xtable SET environment = ‘variable1’ WHERE branchplant = ‘variable2’
made an adapter with the above mentioned SQL,
created a flow service, with 2 inputs as environment and branchplant.
Can anyone help me please?