Most Useful Commands

CommandsDescription
DELETERemoves any of the following:
  • A line from an SQL query or a procedure;
  • A line from a panel in Prompted Query;
  • A line of column information on FORM.MAIN or FORM.COLUMNS;
  • A calculation line from a FORM.CALC panel;
  • A text line on FORM.BREAK, FORM.DETAIL, FORM.FINAL, or FORM.PAGE;
  • Error messages displayed below a query;
  • A row from a table (using the Table Editor).
DISPLAY (DI) Displays an object in temporary storage or in the database.
DISPLAY <name>
Name can be a Query, form, proc, profile or a saved name.
EDIT (ED)Lets you edit:
  • A QMF procedure or an SQL query in temporary storage.
  • A table in the database (using the Table Editor).
ERASERemoves an object from the database.
ERASE <name>
Name can be a Query, form, proc, profile or a saved name.
EXPORTSends:
  • Queries, forms, procedures, reports, charts, and data from temporary storage to a TSO data set;
  • Queries, forms, procedures, and tables from the database to a TSO data set.

EXPORT <Object Type> from <dataset>
Object Type may be DATA,QUERY,TABLE,FORM and PROC.
IMPORTCopies a TSO data set into temporary storage or into the database.
IMPORT <Object Type> from <dataset>
Object Type may be DATA,QUERY,TABLE,FORM and PROC.
LIST (LI)Displays a list of QMF objects stored in the database. When a list is created, it exists throughout the QMF session or until a new list is requested using the LIST
LIST <Type>
Type can be queries, form, proc, table or ALL. UserId and Item Name can contain selection symbols "%" or "_"
RESET object (RE)Restores an object to its initial state. Deletes the names and values of global variables that have been set using the SET GLOBAL.
RESET <Object>
RUN Runs a procedure or query.
RUN <name>
Name can be a query, procedure.
SAVE Stores the contents of a temporary storage area into the database.
SAVE <Object Type>
QMF Object can be a Query, form, Proc, Data or profile.
SET PROFILENavigates among QMF object panels. Shows function keys are available on some panels to display fields that are too long to fit on the base panel or to display the SQL translation of a relational prompted query
SHOW Runs a procedure or query.
RUN Runs a procedure or query.