Using QMF

Writing your own query to change rows

You can also write your own update query by using SQL statements.

To change rows using SQL:

1. On the QMF command line, enter:

   RESET QUERY (LANGUAGE=SQL
   

   The SQL query panel displays.

2. Use the SQL UPDATE statement to change rows.
3. Press the Run function key to run the query.

QMF makes the updates to the table.

Repeat these steps to make additional updates to the table.