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.
If 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.
Copyright © 2005. Sybase Inc. All rights reserved. |