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.

[ Previous Page | Next Page | Contents | Index ]