(CR 426212, CR 426209) In the section titled “Client interaction properties,” replace the description of the MaxResultSize and MaxRowsReturned properties with the following:
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 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 or not the DB2 access service returns warning messages to the client application.
Specifies the maximum number of rows a DB2 access service returns to the client application in a result set.
MaxRowsReturned=integer
0 – unlimited
unlimited
integer is a number of rows. A value of 0 (zero) indicates that the rows returned is an unlimited value.
If the MaxRowsReturned value is exceeded, the DB2 access service issues a warning message and does not send any of the remaining rows in the result set.
The SendWarningMessages property controls whether the DB2 access service returns warning messages to the client application.
The document states that the default is lu62, which is incorrect. For this property there is NO default value.
