Use DB2 user-defined functions in applications

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 stored procedures.

 

Parent topic

DB2 user-defined functions (UDFs)

 

Related concepts

Developing DB2 user-defined functions

 

Related tasks

Creating DB2 user-defined functions using a wizard
Creating DB2 user-defined functions for WebSphere MQ

Related reference
User-defined function catalog by DB2 Universal Database server
User-defined function support by type
Stored procedure and user-defined function support by DB2 Universal Database server type