Scalar functions
Teiid provides an extensive set of built-in scalar functions. For more information, see DML commands and Data types. In addition, Teiid provides the capability for user-defined functions or UDFs. For information about adding UDFs, see User-defined functions in the Translator Development Guide. After you add UDFs, you can call them in the same way that you call other functions.