Specifies the maximum number of bytes a DB2 access service returns to the client application in a result set.
MaxResultSize=integer
0–unlimited
unlimited
integer is a number of bytes.
A value of 0 (zero) indicates that the results size is an unlimited value.
The MaxResultSize value is approximate in that a DB2 access service checks at the end of each row to see if the MaxResultSize value was exceeded.
If the MaxResultSize value is exceeded, the DB2 access service:
Sends the entire row to the client application (not a partial row)
Does not send any of the remaining rows in the result set
Issues a warning message
Typically, the number of bytes returned is less than the value of the MaxResultSize property because the calculations for character columns are based on the defined size, whereas the actual data contained in these columns is usually less.
The SendWarningMessages property controls whether the DB2 access service returns warning messages to the client application. See “SendWarningMessages”.