FIX: The Microsoft OLE DB Provider for DB2 can't read data that is stored in DB2 for Windows V10.5 LONG VARCHAR when DQP linked server SELECT statement is processed

Applies to: Host Integration Server 2016

Symptoms


Consider the following scenario:

  • You run a SQL Server 2008 R2 Distributed Query Processor four-part linked server query SELECT statement against a DB2 for Windows V10.5 database.
  • The data is stored in DB2 for Windows V10.5 as LONG VARCHAR.

In this scenario, you receive the following error message:

Cause


The Microsoft OLE DB Provider for DB2 and the Microsoft DRDA Application Requester Client for DB2 don't convert DB2 for Windows V10.5 LONG VARCHAR data type to the correct Microsoft OLE DB data type consistently. This issue occurs when both of the following are processed:

  • The column schema
  • The query result sets

Resolution


This issue is fixed in Cumulative Update 2 for Host Integration Server 2016.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology Microsoft uses to describe software updates.