You can fully qualify the function using "model-name.func-name".
1 of 1 people found this helpful
isFunction 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.
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.