Filter
Top Products
<Results>
<Query>
<![CDATA[select * from author;]]>
</Query>
<rowid="1">
<AUTHORID>91111</AUTHORID>
<AUTHORNAME>Bjarne Stroustrup</AUTHORNAME>
</row>
<rowid="2">
<AUTHORID>444444</AUTHORID>
<AUTHORNAME>John Steinbeck</AUTHORNAME>
</row>
<rowid="3">
<AUTHORID>2323423</AUTHORID>
<AUTHORNAME>Irwin Shaw</AUTHORNAME>
</row>
<rowid="4">
<AUTHORID>93333</AUTHORID>
<AUTHORNAME>Martin Fowler</AUTHORNAME>
</row>
<rowid="5">
<AUTHORID>92222</AUTHORID>
<AUTHORNAME>Grady Booch</AUTHORNAME>
</row>
<rowid="6">
<AUTHORID>84758345</AUTHORID>
<AUTHORNAME>Judy Blume</AUTHORNAME>
</row>
<rowid="7">
<AUTHORID>89832473</AUTHORID>
<AUTHORNAME>Barbara Kingsolver</AUTHORNAME>
</row>
<Status> <![CDATA[*** Query completed. 7 rows found.
2 columns returned. *** Total elasped time was 1 second(s).]]></Status>
</Results>
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
• In the Neoview Script interface, 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
106 Neoview Script Interface Commands