Starting a SQL query

  1. Make sure that the value of the Language field in your QMF user profile is SQL. If you need more information about setting up your QMF user profile, see Setting up and changing your QMF user profile.
  2. On the QMF command line, enter:
    RESET QUERY

    If you do not want to change your QMF profile, you can enter the following each time you use the RESET command:

    RESET QUERY (LANG=SQL

    The SQL query panel displays.

    Figure 60. The SQL Query panel
     SQL QUERY                               MODIFIED    LINE 1
     
     
     
     
     
     
     
     
     
     
     
     
     
     
     *** END ***
     
     
     1=Help       2=Run        3=End      4=Print     5=Chart        6=Draw
     7=Backward   8=Forward    9=Form     10=Insert   11=Delete       12=Report
     OK, cursor positioned.
     COMMAND ===>                                   SCROLL ===> PAGE
[ Previous Page | Next Page | Contents | Index ]