Makes OLE DB flag LONG data types with DBCOLUMNFLAGS_ISLONG.
- db2cli.ini keyword syntax:
- OleDbReportIsLongForLongTypes = 0 | 1
- Equivalent connection attribute:
- SQL_ATTR_REPORT_ISLONG_FOR_LONGTYPES_OLEDB
- Default setting:
- LONG types (LONG VARCHAR, LONG VARCHAR FOR BIT DATA, LONG VARGRAPHIC
and LONG VARGRAPHIC FOR BIT DATA) do not have the DBCOLUMNFLAGS_ISLONG
flag set, which might cause the columns to be used in the WHERE clause.
- Usage notes:
- The OLE DB client cursor engine and the OLE DB .NET Data Provider
CommandBuilder object generate UPDATE and DELETE statements based
on column information provided by the IBM® DB2® OLE DB Provider. If the generated
statement contains a LONG type in the WHERE clause, the statement
will fail because LONG types cannot be used in a search with an equality
operator. Setting the keyword OleDbReportIsLongForLongTypes to 1 will
make the IBM DB2 OLE DB Provider report LONG types (LONG VARCHAR,
LONG VARCHAR FOR BIT DATA, LONG VARGRAPHIC and LONG VARGRAPHIC FOR
BIT DATA) with the DBCOLUMNFLAGS_ISLONG flag set. This will prevent
the long columns from being used in the WHERE clause.
The OleDbReportIsLongForLongTypes
keyword is supported by the following database servers:
- DB2 for z/OS®
- Version 8 with PTF UQ93890
- Versions later than version 8, PTFs are not required
- DB2 for Linux, UNIX, and Windows
- Version 8.2 (equivalent to Version 8.1, FixPak 7) and later
DB2 Version 9.7 for Linux, UNIX, and Windows