LOBMaxColumnSize CLI/ODBC configuration keyword

db2cli.ini keyword syntax:

LOBMaxColumnSize = integer greater than zero

Default setting:

2 Gigabytes (1G for DBCLOB)

Only applicable when:

LongDataCompat or MapXMLDescribe with a LOB type is used.

Usage notes:

 

This will override the 2 Gigabyte (1G for DBCLOB) value that is returned by SQLGetTypeInfo() for the COLUMN_SIZE column for SQL_CLOB, SQL_BLOB, and SQL_DBCLOB and SQL_XML SQL data types. For SQL_XML, LOBMaxColumnSize must be specified with MapXMLDescribe set to a LOB type. Subsequent CREATE TABLE statements that contain LOB columns will use the column size value you set here instead of the default.