You can use substitution variables to parameterize a procedure. Each time you submit a procedure, it is scanned for substitution variables. You need to provide values for all substitution variables before you run the procedure. Values for substitution variables can come from:
The Enter Substitution Variables Values dialog box opens when you run a dynamic query that contains substitution variables. Use this dialog box to provide values for these substitution variables. QMF for Windows substitutes the values into the query and then sends the query request to the database server.
Provide the following information at the Enter Substitution Variables Values dialog box:
The name of the substitution variable. You cannot modify the variable name.
The value to use for this substitution variable. QMF for Windows substitutes the value for each variable in the SQL statement before it sends the statement to the database server.