JDBC has its own Add property section that can be used as a variable in SQL Query.
Let’s see how it behaves −
Suppose, SQL Query that needs to perform in JDBC step is Select * from Currency where CurrencyCode = ‘xxx’.
In this scenario, CurrencyCode can be changed based on the request input. If the user provides a hard-coded value, JDBC step won’t execute for those currency given in request.
To overcome such scenarios, JDBC supports the add property, where a property Code can be defined and it will keep changing using Property Transfer Step.
SQL Query will run based on the current value of Property Code and SQL Query will parameterize the CurrencyCode =:Code.
Click Add Property + and the name as Code and give value or keep blank to use Property Transfer step to provide it.