Chapter 3. Using DB2 Functions

You can apply three types of built-in functions to data in a DB2 table using SQL: aggregate functions, scalar functions, and table functions. In addition, scalar and table functions are provided for MQSeries® and XML operations—these are covered separately toward the end of this chapter.

You can use these functions to further simplify the requirements of complex data access.


DB2 also provides the capability for users to create their own functions. This capability, called user-defined functions, is discussed ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.