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

ids_sqt_152.html#ids_sqt_152 shows how to include SPL routines in your SELECT statements.

Data encryption functions 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.