Description

queryname

Name of a query stored in the database. The query stored in the database is unchanged, and the query in QMF temporary storage is replaced with a copy of the stored query.

TARGET

Controls the placement of the converted query.

QUERY

Places the converted query on the SQL query panel. The query in your temporary storage is replaced with the converted query.

VARS

Places the converted query and related information about the query in QMF global variables beginning with DSQQC_. (See Appendix B. QMF Global Variable Tables for more information.) If ISPF is available, the converted query is also placed in the ISPF dialog manager variable pool. ISPF is not available in CICS. The query in your temporary storage is not changed. Only the global variables and the ISPF variable pool are changed.

CONFIRM

Indicates whether a confirmation panel is displayed when this command will replace an existing object in the database.

SUBSTITUTE

Indicates whether to replace substitution variables in your query with values.

YES

If you have variables in your query, QMF attempts to substitute values for them. If all the variables are defined, no prompt panel is displayed. If QMF cannot resolve all the variables, it prompts you to enter values. QMF first looks at the command for a variable definition before looking at existing global variables.

NO

No variable names in your query are resolved.

&variable

Identifies a substitution variable for the CONVERT 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 CONVERT 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.