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

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 63).
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.
Considerations
• 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.
• To reset the number of displayed rows, enter this command:
SET LIST_COUNT 0
Examples
• This command specifies that the number of rows to be displayed by SELECT statements is
five:
SQL>set list_count 5
SQL>select empnum, first_name, last_name
from persnl.employee
order by empnum;
EMPNUM FIRST_NAME LAST_NAME
------ --------------- --------------------
1 ROGER GREEN
23 JERRY HOWARD
29 JANE RAYMOND
32 THOMAS RUDLOFF
39 KLAUS SAFFERT
--- 5 row(s) selected. LIST_COUNT was reached.
120 NCI Commands