Neoview Script Guide (R2.2)

SQL>show idletimeout
IDLETIMEOUT 30 min(s)
• 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]
For more information, see “Setting and Showing the Idle Timeout Value for the Session” (page 57).
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. This command
can be executed in all modes.
Syntax
SHOW LASTERROR
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
Examples
This command shows the last error in the current session:
SQL>select * from emp;
*** ERROR[4082]Object NEO.SCH.EMP does not exist or is inaccessible.
SQL>show lasterror
LASTERROR 4082
SHOW LIST_COUNT Command
The SHOW LIST_COUNT command displays the maximum number of rows to be returned by
SELECT statements in the current Neoview Script session. The default is zero, which means that
all rows are returned.
Syntax
SHOW LIST_COUNT
Considerations
• In the Neoview Script interface, you must enter the command on one line. The command
does not require an SQL terminator.
• You can execute this command only in SQL mode.
Examples
• This command shows that SELECT statements return all rows in the current session:
SHOW LASTERROR Command 121