MX Release 3.2 (H06.25+, J06.14+)

-------------------------------------------------------------

EMPLIST MGRLIST

SQL>

RESET LASTERROR command

The reset lasterror command resets the last error code to zero.

Syntax

RESET LASTERROR

Considerations

You must enter the command in one line.

Examples

The following command resets the last error in the current session:

SQL>select * from emp;

*** ERROR[4082]Object CAT.SCH.EMP does not exist or is inaccessible.

SQL>show lasterror

LASTERROR 4082

SQL>reset lasterror

SQL>show lasterror

LASTERROR 0

RESET PARAM command

The reset param command clears all parameter values or a specified parameter value in the

current session.

Syntax

RESET PARAM [param-name]

param-name

is the name of the parameter for which you specified a value. Parameter names are

case-sensitive. For example, the parameter ?pn is not equivalent to the parameter ?PN.

param-name can be preceded by a question mark (?), such as ?param-name.

If you do not specify a parameter name, all the parameter values in the current session are

cleared.

Considerations

• You must enter the command in one line.

• To clear several parameter values but not all, you must use a separate reset param command

for each parameter.

Example

The following command clears the setting of the ?sal parameter, and the set param command

sets it to a new value:

104 RMXCI commands