What Is a User-Defined Function?

What Is a User -Defined Function?

A user-defined function, or UDF for short, is procedural functionality added to DB2 by the user. The UDF, after coded and implemented, extends the functionality of DB2 SQL by enabling users to specify the UDF in SQL statements just like built-in SQL functions.

User-defined functions are ideal for organizations wanting to utilize DB2 and SQL to perform specialized, corporate routines performing business logic and data transformation.