[ https://issues.jboss.org/browse/TEIID-5714?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5714: ---------------------------------- Workaround Description: An ugly workaround would be to use a procedure: begin create local temporary table t (c bigdecimal); loop on (SELECT TAB1.STRINGCOL, TAB1.DATE FROM MODEL2.TABLE1 TAB1) as x begin insert into t values (MODEL1."dbo.examplefunc"(STRINGCOL, DATE, TRUE) ); end select * from t; end If there is another source table on MODEL1 another slightly less ugly workaround would be to use a subquery associated with MODEL1: SELECT (SELECT MODEL1."dbo.examplefunc"(TAB1.STRINGCOL, TAB1.DATE, TRUE) FROM MODEL1.TABLEX LIMIT 1) MODEL2.TABLE1 TAB1 -- This message was sent by Atlassian Jira (v7.12.1#712002)