MaxRowsReturned property

The MaxRowsReturned property specifies the maximum number of rows retrieved in a result set. (A result set is all or part of the results from a processed SQL statement.) However, one SQL request can produce multiple result sets.

NoteIf the number of rows exceeds the value of the MaxRowsReturned property, the DB2 access service returns the maximum number of rows and issues a warning message. However, the DB2 access service issues warning messages only when the SendWarningMessages property is enabled.