DB2 graphic  QMF Version 8

Nesting scalar functions within scalar functions

Suppose you want to know the month and day of interview for all applicants interviewed by manager 140, and you want the result in USA format. When you run this query:

SELECT SUBSTR((CHAR(INTDATE, USA)),1,5)
  FROM Q.INTERVIEW
  WHERE MANAGER = 140

QMF produces this report:

DATE
----------
04/07
09/30


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004