Chapter 3. Using DB2 Functions
In This Chapter
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.
Note
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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.