Commands you can use on the list of database objects

Your site might have defined a command with the same name as a QMF command. Depending on the command you use, there might be some restrictions or special considerations you need to know about.

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

Retrieves an object from the database and displays it.

EDIT

Edits a table in the database using the Table Editor.

The Table Editor operates on all tables except those that contain columns defined as BINARY, VARBINARY, BLOB, or XML. If a table contains CLOB or DBCLOB columns, you cannot edit those columns, but you can edit other columns in the table. To edit a table that contains DECFLOAT data, the processor on which QMF is running must support decimal floating point instructions.

If you want to edit a query or procedure, you must display it first.

ERASE

Deletes an object from the database.

EXIT

Ends your QMF session.

EXPORT

Exports QMF objects that are stored in the database directly from the database to a UNIX file, TSO data set, or CICS® queue.

IMPORT

Imports QMF objects directly from a UNIX file, TSO data set, or CICS queue.

LAYOUT

Displays the format of a report that is produced from a given form without using any data.

You can use LAYOUT only with form objects, and only in an environment in which both REXX and ISPF are available.

PRINT

Prints a database object.

RUN

Runs a query or procedure that is stored in the database.

SAVE

Replaces the object in the database with the object currently in temporary storage. For example, if you enter the following next to a query on the database object list, QMF replaces the query in the database with the query currently in temporary storage:

SAVE QUERY AS objectname