This content has been marked as final.
Show 2 replies
-
1. Re: How do I store data from virtual procedure into table?
rareddy Oct 26, 2017 12:08 PM (in response to shiloh.jordan)Take the "Electors008." portion of the path and see if that makes any difference.
-
2. Re: How do I store data from virtual procedure into table?
shawkins Oct 26, 2017 3:59 PM (in response to rareddy)You cannot direct use a view column as a parameter, but there is a related syntax - see procedural relational DML Commands · Teiid Documentation
You would instead use:
select cols ..., filepath from testProc
and add filepath as a column to the view.
Then the user could issue:
select * from FinalView_Tbl where filepath = 'something'
and get a result. However the engine would produce an error if you just issued "select * from FinalView_Tbl"