I want to use procedural relational command with optional parameters for virtual procedures. I have created a BaseTable with call to a virtual procedure in transformation.
Using exec|call syntax for store procedure passes in default value for the parameters but I do not know how I can pass in values for these parameters when using this base table.
While looking for fix I came across following post. I have same scenario. Can anybody guide me on this?
A procedural relational command currently does not support the notion of default parameters. As the other post explains the results and/or validation of what you are trying to execute becomes murky when applying defaults. What is the scenario for this?