After you create a DB2® user-defined
function (UDF), you can refer to the function in SQL statements.
You can refer to user-defined functions in SQL statements as follows:
- Table UDFs can only be invoked in the FROM clause of an SQL statement.
- Scalar UDFs can be referenced in SQL statements wherever an expression
is valid.
See the topic "Routines in application development" and related
topics in the
DB2 Information
Center or the
DB2 Application
Development Guide or
SQL Reference for more detailed
information about DB2 user-defined
functions and how to use them in applications. See
Authorities for DB2 stored
procedures and user-defined functions for a list of DB2 privileges and authorities that
are required to create and work with UDFs.