SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-46

SET LIST_COUNT Command

The SET LIST_COUNT command is used to set the maximum number of rows to be

displayed in SELECT statements executed after this command.

You can use SET LIST_COUNT only within an MXCI session.

num-rows

is a positive integer that specifies the maximum number of rows of data to be

displayed from the execution of SELECT statements after the execution of this

command.

To reset the number of displayed rows, issue SET LIST_COUNT without specifying

the number of rows. The system-defined default setting is 4,000,000. To terminate

the listing of rows, use the MXCI break key.

Considerations for SET LIST_COUNT

Range for Number of Rows

The allowable values for the list count are from 0 to the maximum value of an unsigned

integer. If the specified value is 0, the number of retrieved rows is zero. If the specified

value is greater than the maximum value of an unsigned integer, the number of

retrieved rows is that maximum value.

Examples of SET LIST_COUNT

•

Specify the number of rows to display:

SET LIST_COUNT 5;

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.

SET LIST_COUNT [num-rows]