You can change column names, change row conditions, and sort information in a query you have saved. You cannot change table names, but you can delete a table and specify a new one.
To change information in a query:
The appropriate change panel, like the one in Figure 58, displays.
PROMPTED QUERY USERID.MYQUERY MODIFIED LINE 1 +--------------------------------------------------------------+ Tables: | Change Column | Q.STAFF | | | Type a column name, expression (A+B, etc.), or a summary | Columns: | function (SUM, etc.). You can use the following arithmetic | NAME | operators: add(+), subtract(-), multiply(*), and divide(/). | > ... | | JOB | ( ) | | ( ) | Row Condit | ( ) | If JOB I | ( ) | | ( ) | *** END ** +--------------------------------------------------------------+ | F1=Help F4=List F12=Cancel | +--------------------------------------------------------------+
The Prompted Query panel displays with the changed information in the echo area.