MaxResultSetRows

Description

Sets or returns the soft limit on the number of records returned in a result set.

The MaxResultSetRows value is the soft limit value that limits the number of rows in the ResultSet. Clients can override the value of the soft limit, as long as the soft limit value is less than the hard, or absolute, limit. When the value of MaxResultSetRows is 0, the hard limit is used.

Note: This method became available in version 7.1.

Syntax

VBScript


resultset.MaxResultSetRows 
resultset.MaxResultSetRows limit

Perl


$resultset->GetMaxResultSetRows();
$resultset->SetMaxResultSetRows($limit);

Identifier: Description
resultset: A ResultSet object, representing the rows and columns of data resulting from a query.
limit: A Long specifying the limit of rows returned in a ResultSet.
Return value: Returns a Long containing the limit for the number of rows returned in a ResultSet.

Example

Perl

 # limit a ResultSet to 10000 rows
 my $CQWorkSpace = $CQSession->GetWorkSpace();
 my $qry = $CQWorkSpace->GetQueryDef("Public Queries/Some Big Query");
 my $ResultSet = $CQSession->BuildResultSet($qry);
 $ResultSet->SetMaxResultSetRows(10000);
 $ResultSet->Execute();