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

6> INSERT INTO COURSE1 VALUES
('C11','INTRO TO CS','FOR ROOKIES',3, 100, 'CIS');
7> INSERT INTO COURSE1 VALUES
('C55','COMPUTER ARCH.','VON NEUMANN''S MACH.',3,100,'CIS');
SET IDLETIMEOUT Command
The SET IDLETIMEOUT command sets the idle timeout value for the current session. The idle
timeout value of a session determines when the session expires after a period of inactivity. The
default is 30 minutes.
Syntax
SET IDLETIMEOUT value
value
is an integer representing the idle timeout value in minutes. Zero represents an infinite
amount of time, meaning that the session never expires.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• If you execute this command in a script file, it affects the session in which the script file runs.
You can specify this command in PRUN script files. However, running this command from
a PRUN script file does not affect the idle timeout value for the current session.
• To reset the default timeout value, enter this command:
SET IDLETIMEOUT 30
Examples
• This command sets the idle timeout value to four hours:
SQL>set idletimeout 240
• This command sets the idle timeout value to an infinite amount of time so that the session
never expires:
SQL>set idletimeout 0
• To reset the idle timeout to the default, enter this command:
SQL>set idletimeout 30
SQL>
For more information, see “Setting and Showing the Idle Timeout Value for the Session” (page 61).
SET LIST_COUNT Command
The SET LIST_COUNT command sets the maximum number of rows to be returned by SELECT
statements that are executed after this command. The default is zero, which means that all rows
are returned.
Syntax
SET LIST_COUNT num-rows
num-rows
is a positive integer that specifies the maximum number of rows of data to be displayed by
SELECT statements that are executed after this command. Zero means that all rows of data
are returned.
SET IDLETIMEOUT Command 121