Specifies the maximum number of bytes a DB2 access service returns to the client application in a result set.
MaxResultSize=integer
0–2147483646
2147483646
integer is a number of bytes.
A value of 0 (zero) defaults to 2,147,483,646 bytes (the default 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”.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
