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.