Description

objectname

The name of a QMF object in the database. An object owned by another user must be qualified with the owner's name.

&variable

Identifies a substitution variable for the RUN command. Variables can be assigned values up to 55 single-byte characters long with this option. Up to ten substitution variables can be specified in a single command.

The variable name must be prefaced with an ampersand. Use two ampersands if you issue the RUN command from within a linear procedure.

value

The character string that makes up the content of the substitution variable.

A value that contains blank characters must be surrounded with delimiters. Valid delimiters for a substitution variable value are single quotes, double quotes, and parentheses. When the delimiters are quotation marks, the quotation marks are included as part of the value. When the delimiters are parentheses, the parentheses are not included as part of the value.

QUERY Options

CONFIRM

Indicates whether a confirmation panel is displayed when the query will:

• change an existing object in the database.
• exceed a cost estimate limit specified in the Resource Limit Facility (DB2 Predictive Governor).

FORM

Indicates which QMF FORM to use when formatting the selected data.

newform

If this option is omitted QMF creates a new form object, replacing the current form in temporary storage. The new form will match the data selected by the query. It will provide default formatting for the displayed report.

FORM

The QMF FORM currently in temporary storage is used. A FORM must be in temporary storage to use this choice.

The report can be displayed if the current FORM is appropriate for the selected data.

formname

The name of a QMF FORM in the database. A form owned by another user must be qualified with the owner's name. Additional requirements are:

• The FORM must exist in the database at the current location.
• You must be authorized to use a form owned by another user.

The FORM specified becomes the current FORM in temporary storage. The report can be displayed if this FORM is appropriate for the selected data.

ROWLIMIT

Sets a limit for the number of data rows returned by a query. Use this option only when you want to restrict how many rows of data are available for the report, from 1 to 99999999 rows.

integer

An integer between 1 and 99999999.

PROC Options

ARG

The argument string to pass to a QMF procedure with logic (REXX procedure). One argument up to 80 characters long can be passed with this option.

The argument string is received by the REXX procedure using the REXX command PARSE ARG or the REXX function ARG(1).

value

The character string that makes up the content of the argument.

A value that contains blank characters must be surrounded with delimiters. Valid delimiters for an argument value are single quotes, parentheses, and double quotes. When the delimiters are double quotes, the double quotes are included as part of the value.