Using QMF

Adding or deleting lines in a SQL query

You can add new lines to an SQL query, or delete lines you no longer need. You can change the query before or after you run it.

To add lines:

1. If you have not saved the query in the database, display the query again by entering SHOW QUERY on the QMF command line. Or, you can display the query by pressing the Query function key. If you saved the query in the database, enter DISPLAY QUERY queryname.
2. Move the cursor above the place where you want to add information.
3. Press the Insert function key. QMF displays a blank line.
4. Type the information on the blank line. For this example, add a condition to select only employees from department 38.

   SELECT NAME, YEARS, SALARY
     FROM Q.STAFF
     WHERE DEPT=38
     ORDER BY NAME
   

To delete a line:

Move the cursor to the line you want to delete, and press the Delete function key.