<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-rowsis 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