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.