Types of functions
There are several ways to classify functions. One way to classify
functions is as built-in functions, user-defined functions, or cast functions
that are generated for distinct types.
Built-in functions
Built-in functions are functions that come with Db2 for z/OS® . These functions provide a single-value result.
User-defined functions
User-defined functions are functions that are created using the CREATE FUNCTION statement and registered to the Db2 in the catalog. These functions allow users to extend the function of Db2 by adding their own or third party vendor function definitions.
Generated user-defined functions for distinct types
Generated user-defined functions for distinct types (also called cast functions ) are functions that Db2 automatically generates when a distinct type is created using the CREATE TYPE statement.
Additional way to classify functions
Another way to classify functions is as aggregate, scalar, or table functions, depending on the input data values and result values.