Neoview Command Interface (NCI) Guide (R2.3)

SHOW IDLETIMEOUT Command
The SHOW IDLETIMEOUT command displays the idle timeout value of the current NCI session.
The idle timeout value of a session determines when the session expires after a period of inactivity.
The default is 30 minutes.
Syntax
SHOW IDLETIMEOUT
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
• This command shows that the idle timeout value of the session is 30 minutes, which is the
default:
SQL>show idletimeout
IDLETIMEOUT 30 min(s)
Elapsed time:00:00:00:078
• This command shows that the idle timeout value of the session is four hours:
SQL>show idletimeout
IDLETIMEOUT 240 min(s)
• This 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]
• This 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 Idle Timeout Value for the Session” (page 63).
SHOW LASTERROR Command
The SHOW LASTERROR command displays the error of the last SQL statement that was executed.
If the query was successful, 0 is returned; otherwise an SQL error code is returned.
Syntax
SHOW LASTERROR
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• SHOW LASTERROR can be executed in all modes.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
SHOW IDLETIMEOUT Command 133