It is possible to use WhereScape RED parameters in a WHERE clause, even when the parameters screen is not displayed during procedure generation.
An example of this on SQL Server would be to have a parameter named param1 with a value of 1.
In your WHERE clause box you could enter
WHERE MyColumn = dbo.WsParameterReadF('param1')
On Oracle
WHERE MyColumn = (select WsParameterRead('param1') from dual)
Would achieve the same result.
You can find WsParameterRead and WsParameterReadF documented in the 'Callable Routines' section of the WhereScape RED User Guide.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article