Using QMF

Nesting column functions within scalar functions

Suppose that you want to know the year in which the last project in department 20 will be initiated. If you run this query:

SELECT YEAR(MAX(STARTD))
  FROM Q.PROJECT
  WHERE DEPT = 20

QMF produces this report:

+--------------------------------------------------------------------------------+
|    LAST                                                                        |
|   PROJECT                                                                      |
|    START                                                                       |
|----------                                                                      |
|      1997                                                                      |
+--------------------------------------------------------------------------------+