Summary

This chapter introduced sample syntax and results for functions in basic SELECT statements to query a relational database and to manipulate the returned data. Using Functions in SELECT Statements shows how to perform the following actions:

• Use the aggregate functions in the projection clause to calculate and retrieve specific data.
• Include the time functions DATE, DAY, MDY, MONTH, WEEKDAY, YEAR, CURRENT, and EXTEND plus the TODAY, LENGTH, and USER functions in your SELECT statements.
• Use conversion functions in the SELECT clause to convert between date and character values.
• Use string-manipulation functions in the SELECT clause to convert between upper and lower case letters or to manipulate character strings in various ways.

Using SPL Routines in SELECT Statements shows how to include SPL routines in your SELECT statements.

Using Data Encryption Functions (IDS) shows how the use of the SET ENCRYPTION statement and built-in encryption and decryption functions can prevent users who cannot provide a password from viewing or modifying sensitive data.