qmf commands

LIST QUERIES

LIST TABLES


Command What it does

CONVERT Converts a prompted, QBE, or SQL query into an equivalent SQL
query. The comments in the original query do not appear in the
converted query.

DISPLAY Retrieve an object from the database and display it on your
terminal.

EDIT Edit a table in the database using the Table Editor. From the
database object list, you can only use the EDIT command to edit
a table. If you want to edit a query or procedure, you must
display it first.

ERASE Delete an object from the database.

EXIT End your QMF session.

EXPORT Export QMF objects stored in the database directly from the
database into a file (CMS), data set (TSO and CICS/MVS), or
queue name (CICS).

IMPORT Import QMF objects directly into the database from a file
(CMS), data set (TSO and CICS/MVS), or data queue name (CICS).

LAYOUT Display the format of a report produced from a given form
without using any data. You can only use LAYOUT with form
objects, and only in an environment in which both REXX and ISPF
are available.

PRINT Print a database object.

RUN Execute a query or procedure stored in the database.

SAVE Replace the object in the database with the object currently in
temporary storage. For example, if you enter:

SAVE QUERY AS

next to a query on the database object list, QMF replaces that
query in the database with the query currently in temporary
storage.


Using a Placeholder on the List of Database Objects

You can use a slash / as a placeholder to represent the object type, owner,
and name in a QMF command.

For example, entering the following in the Action area for a table object:

EDIT / (MODE=ADD

means the same as entering:

EDIT TABLE owner.tablename (MODE=ADD

where owner.tablename is the owner and name of the table listed.

You can also use /T if you just want to specify the object type, or /N if
you just want to specify the owner and name. The /T and /N placeholders
are especially useful if you are issuing a command to run a user-written
application that requires just the object type or just the object owner an
name.

If you are displaying a list from a remote location, the placeholder
symbols (/ and /N) include the location with the owner and name.

You can also display the prompt panel for a command with the object type
and the object owner and name filled in. To do this, type the command
followed by the / placeholder and a question mark.

For example, to display the RUN Command Prompt panel for the DEPTQUERY
object, enter "RUN / ?" in the Action area next to the object. The RUN
QUERY Command Prompt panels display. The first panel already has the







The placeholder options that you can enter are:

- "/T" - to display object type
- "/N" - to display owner.name
- "/" - to display both object type and owner.name