-
1. Re: Virtual procedure with Function=true
rareddy Mar 11, 2013 1:38 PM (in response to virtualdatabase)You can fully qualify the function using "model-name.func-name".
Ramesh..
-
2. Re: Virtual procedure with Function=true
shawkins Mar 11, 2013 1:43 PM (in response to rareddy)1 of 1 people found this helpfulisFunction is effectively ignored for calling virtual procedures in 5.3.1. For later versions of Teiid/Teiid Designer setting isFunction to true will mean that the virtual procedure is supposed to functionally equivalent to a UDF definition (you then won't be able to define the function with Teiid procedure sql). So there is no current or future provision for calling Teiid virtual procedure logic as if it were a function.
The workaround is to just use a scalar subquery.
Steve
-
3. Re: Virtual procedure with Function=true
rareddy Mar 11, 2013 1:59 PM (in response to virtualdatabase)In that case use Function model to define your Function rather than using the Virtual Model's procedure as Function. You need to provide the function implementation in a java class. Check the documentation on User Defined Functions. Note in Teiid 8.x series Function Model is deprecated, and what you doing will work in Teiid 8.2.
Ramesh..