Calling WsParameterRead inside a WHERE clause

Modified on Tue, 13 Sep 2016 at 08:27 AM

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

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article