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

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:

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

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

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

Learn about the terminology Microsoft uses to describe software updates.