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

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.5 Software

111

112

113

114

115

116

117

118

119

120

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.

SQL>

• This command resets the number of displayed rows to all rows:

SQL>set list_count 0

SQL>select empnum, first_name, last_name

+>from persnl.employee

+>order by empnum;