Scenario Link to heading

In Logic Apps Standard we now have this in-app DB2 actions, no need for managed connections, just make DB2 calls directly from the Logic App.

While using these shapes, the execute query in particular, it took me a while to figure out how to set the parameter for the query.

Adjusting the query and parameter Link to heading

The way it worked for me is using the ? sign for the parameter, and a numeric index for the parameter definition.

This was after trying named parameters, the @ sign, and reading the links on the first two pages of Bing results for this question without any luck. This solution worked for me, however it might be different for you depending on the underlying database and its configuration, in my case this is against an Informix 14 database.