This content has been marked as final.
Show 1 reply
-
1. Re: Does DV Extend SQL, let you use procedural statements anywhere?
shawkins Feb 4, 2016 2:51 PM (in response to werx.io)Procedure statements can only be used where a procedure is expected - BNF for SQL Grammar - Teiid 8.13 - Project Documentation Editor
So to implement full flow control you will need a virtual procedure.
A view doesn't have a proper notion of parameters and only allows for simpler constructs, like common table expressions, case expression, etc.