Specifies the maximum number of bytes in character columns a DB2 access service returns to the client application.
TextSize=integer
0 - 2147483647
2147483647
integer is a number of bytes.
A value of 0 (zero) defaults to 2147483647 (the default value).
A DB2 access service truncates data exceeding the TextSize length and does not issue a warning message.
The DB2 access service returns character data longer than the value of the XNLChar and XNLVarChar configuration property values as CS_TEXT datatype.
For a DB2 access service, how the data is queried determines the text and image results processing. Queries with a select list of a single text or image column results in data streaming. If data is streamed, a maximum of 2,147,483,647 bytes may be returned per text and image value. Queries with a select list containing more than one column results in bound data. All bound data, including text and image is limited to 32,767 bytes. The textsize configuration property applies to both streaming and bound character data.
