DB2 graphic  QMF Version 8

Examples

  1. To convert a query in QMF temporary storage into an SQL query and substitute a value of 38 for the variable DEPT in the converted query:
      CONVERT QUERY ( &DEPT=38
  2. To improve the organization of an existing SQL query. For example, suppose the SQL query in temporary storage was:
    SELECT 'JOB',JOB,'SERIAL',ID FROM Q.STAFF 
        WHERE ID<99 ORDER BY 2
    The converted query after running the CONVERT command would be:
      SELECT 'JOB', JOB, 'SERIAL', ID
      FROM Q.STAFF
      WHERE ID < 99
      ORDER BY 2
  3. To convert a query from the database named QBEQUERY into a SQL query in QMF temporary storage:
      CONVERT QUERY QBEQUERY
  4. To convert a query from the database named MYQUERY into a SQL query, and put it into the ISPF dialog manager pool and the global variable pool:
      CONVERT QUERY MYQUERY ( TARGET=VARS


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