MX Release 3.1 (H06.23+, J06.12+)

Resetting the parameters

To change the value of a parameter, specify the name of the parameter in the reset param

command, and then use the set param command to change the setting. For example, suppose

that you want to change the salary parameter to 80000.00:

SQL>reset param ?sal

SQL>set param ?sal 80000.00

Running the reset param command without specifying a parameter name clears all parameter

settings in the session, for example:

SQL>reset param

SQL>show param

*** ERROR[29428] No parameters found.

SQL>

To use the parameters, which you had set before, you must set them again in the session:

SQL>set param ?dn 1500

SQL>set param ?sal 80000.00

SQL>show param

dn 1500

sal 80000.00

SQL>

For the syntax of the reset param command, see the “RESET PARAM command” (page 82).

Executing a prepared SQL statement

To run a prepared SQL statement, use the execute statement.

For example, the following execute statement runs the prepared empsal statement, which does

not have any parameters:

SQL>execute empsal;

SALARY

----------

137000.00

90000.10

75000.00

138000.40

56000.00

136000.00

80000.00

70000.00

175500.00

90000.00

118000.00

--- 11 row(s) selected.

The following execute statement runs the prepared empcom statement, which has one named

parameter, ?dn, and was set by set param for the department number:

Running SQL statements 43