LOBMaxColumnSize CLI/ODBC configuration keyword
Overrides the default value in the COLUMN_SIZE column for LOB data types.
- 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.