SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

Syntax
SHOW IDLETIMEOUT
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Examples
• The following command shows that the idle timeout value of the session is the default, thirty
minutes:
SQL>show idletimeout
IDLETIMEOUT 30 min(s)
Elapsed time:00:00:00:078
• The following command shows that the idle timeout value of the session is four hours:
SQL>show idletimeout
IDLETIMEOUT 240 min(s)
• The following command shows that the idle timeout value is an infinite amount of time, meaning
that the session never expires:
SQL>show idletimeout
IDLETIMEOUT 0 min(s) [Never Expires]
• The following command displays the elapsed time information because set timing command
is enabled:
SQL>set timing on
SQL>show idletimeout
IDLETIMEOUT 0 min(s) [Never Expires]
Elapsed time:00:00:00:078
For more information, see “Setting and showing the idletimeout value for the session” (page 56).
SHOW LASTERROR command
The show lasterror command displays the error returned from the execution of the last SQL
statement. The command returns zero, if the last SQL statement was successfully run.
Syntax
SHOW LASTERROR
Considerations
• You must enter the command in one line.
• If the set timing command is set to on, the elapsed time information appears.
Examples
The following command shows the last error in the current RMXCI session:
SQL>select * from emp;
*** ERROR[4082]Object CAT.SCH.EMP does not exist or is inaccessible.
126 RMXCI commands