DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition

Chapter 3. Using DB2 Functions

In This Chapter

• Aggregate Functions

• Scalar Functions

• Table Functions

• MQSeries Built-In Functions

• XML Built-in Functions

• The RAISE_ERROR Function

• The CAST Operation

• Built-In Function Guidelines

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 ...