Using DDL this it looks like DDL Metadata · Teiid Documentation:
CREATE VIRTUAL FUNCTION func(p1 bigdecimal) RETURNS integer as return <some expression>;
This is not yet supported in Teiid Designer.
A possible drawback is that currently a sql defined function is not inlined, which may inhibit pushdown if the sources aren't marked as supporting the function.
I want to use this in my sql query for the VDB to avoid code repetition.
select getname(Id) from table;
How can i make that work? is there a possible way to make it work this way or i should wait for a fix in a future release ??
> How can i make that work?
To clarify are you using Teiid Designer or a VDB that defines it's metadata through import / ddl? And do you want getname to pushdown to the source or just be able to be evaluated in Teiid?