Specifies the maximum return block size for LOB or XML
data.
- db2cli.ini keyword syntax:
- MaxLOBBlockSize = 0 | ... | 2147483647
- Default setting:
- There is no limit to the data block size for LOB or XML data.
- Equivalent connection or statement attribute:
- SQL_ATTR_MAX_LOB_BLOCK_SIZE
- Usage notes:
- During data retrieval, the server will include all of the information
for the current row in its reply to the client even if the maximum
block size has been reached.
If both MaxLOBBlockSize and the db2set
registry variable DB2_MAX_LOB_BLOCK_SIZE are specified, the value
for MaxLOBBlockSize will be used.
DB2 Version 9.7 for Linux, UNIX, and Windows