MX Release 3.1 (H06.23+, J06.12+)

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 run after this command. Zero means that all rows of data are

returned.

Considerations

• You must enter the command in one line.

• To reset the number of displayed rows, enter the following command:

set list_count 0

Examples

• The following 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>

• The following 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;

EMPNUM FIRST_NAME LAST_NAME

------ --------------- --------------------

1 ROGER GREEN

23 JERRY HOWARD

29 JANE RAYMOND

32 THOMAS RUDLOFF

39 KLAUS SAFFERT

43 PAUL WINTER

65 RACHEL MCKAY

...

995 Walt Farley

--- 62 row(s) selected.

SQL>

88 RMXCI commands