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
Let’s say you have a sql query that has a where clause that need 2 params ( between ? and ?)
How do you supply 2 params to wm.db.execSql in * $dbParamValues
Why not create your SQL statement by embedding variable names in the string and having the “Perform Variable Substition” switched on.
e.g.
“SELECT * from tab1 where col1 = ‘%var1%’ and col2 = '%var2%”