DB2 graphic  QMF Version 8

Examples

  1. To display a prompt panel for the QMF RUN command:
      RUN ?
  2. To run the query currently in QMF temporary storage and format the report with a form from the database (REPORT3) owned by another user (MARIA):
      RUN QUERY ( FORM=MARIA.REPORT3
  3. To run your query from the database (SALESQ) and provide a value for the substitution variable YR:
      RUN QUERY SALESQ ( &YR=1999
    If the same command were placed in a QMF linear procedure it would be written as:
      RUN QUERY SALESQ ( &&YR=1999
  4. When you issue a RUN QUERY command, it runs a query stored at the current location (optionally using a form found at the current location). For example, if the query STATSCHK contains the following:
    SELECT * FROM JOHNSON.STATUS
    the command:
    RUN QUERY STATSCHK (FORM=FORMCHK
    retrieves the query, form, and data from the current location.

    However, if the query is as follows:

    SELECT * FROM BILLINGS.JOHNSON.STATUS

    the command:

    RUN QUERY STATSCHK (FORM=FORMCHK

    retrieves the data from the BILLINGS location and the query and form from the current location.

  5. Using the RUN command in a QMF procedure:
    PROC MODIFIED LINE 1
    
    RUN QUERY
    +"LONGOWNERID23456789012345678901234567890123456789012345678901234567890123
    +4567890123456789012345678901234567890123456789012345678"."LONGNAME9012345
    +6789012345678901234567890123456789012345678901234567890123456789012345678
    +901234567890123456789012345678"


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