User-defined function support by type

You can create several different types of UDFs (UDFs) using the workbench.

You can create the following types of UDFs:

• SQL scalar UDFs for DB2 Universal Database for Linux, UNIX, and Windows

• SQL table UDFs for DB2 Universal Database for Linux, UNIX, and Windows

• Special UDFs that work with the following data types or sources: WebSphere MQ message queues, UDFs that access the operations of Web services.

A scalar function returns a single value each time that it is called. A table function returns a table.

You can use the New WebSphere MQ UDF wizard to create a UDF that prepares the contents of a queued message to be inserted into a DB2 table with a simple SQL query. WebSphere MQ is a middleware system that manages the queuing of messages so that applications can communicate in a distributed, heterogeneous environment. You can access WebSphere MQ from DB2 through UDFs. Because UDFs form part of an SQL statement, you can blend queuing and database operations together.

You can use the Web Service User-Defined Function wizard to create DB2 user-defined functions (UDFs) that can access the operations of Web services.

DB2 Universal Database does not fully support stored procedures and UDFs that contain distinct types (user-defined types) as parameters.

 

Parent topic

DB2 user-defined functions (UDFs)

 

Related concepts

Developing DB2 user-defined functions
Using DB2 user-defined functions in applications

 

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
Stored procedure and user-defined function support by DB2 Universal Database server type