LobAsLongDataMode IBM data server driver configuration keyword
Reports large object (LOB) data as long data types.
- Equivalent CLI keyword
- LongDataCompat
- Equivalent IBM® data server provider for .NET connection string keyword
- N/A
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="LobAsLongDataMode" value="0 | 1"/>- Default setting:
- Reference LOB data as large object types.
- Equivalent connection attribute:
- SQL_ATTR_LONGDATA_COMPAT
- Usage notes:
- The LobAsLongDataMode keyword indicates what data types the application expects when you are working with large object (LOB) columns.
- 0
- Reference LOB data as large object types.
- 1
- Report LOB data as long data types for CLI applications only.
Table 1. Corresponding large object and long data types for LOB data Database data type Large objects (0 - Default) Long data types (1 - CLI/ODBC) CLOB SQL_CLOB SQL_LONGVARCHAR BLOB SQL_BLOB SQL_LONGVARBINARY DBCLOB SQL_DBCLOB SQL_LONGVARGRAPHIC* * If the GraphicDefaultDescribeMapping keyword is set with the LobAsLongDataMode keyword, DBCLOB columns return an SQL type of SQL_LONGVARCHAR if the GraphicDefaultDescribeMapping keyword value is 1 and SQL_WLONGVARCHAR if the GraphicDefaultDescribeMapping keyword value is 2. The LobAsLongDataMode keyword can be set when you are running ODBC applications that cannot handle the large object data types.
The LOBMaxColumnSize keyword can be used with the LobAsLongDataMode keyword to reduce the default size that is declared for the data.