Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.
View products that this article applies to.
The Microsoft
ADO.NET provider for DB2 fails to read data stored in DB2 for z/OS V11 BLOB and
CLOB columns that are greater than 1,048,576 bytes.
In this case, you may get the following error message:
Not supported LOB data format. SQLSTATE HY000 with SQLCODE -343
The Microsoft ADO.NET Provider for DB2 and the underlying Microsoft DRDA Application Requester Client for DB2 do not process DB2 for z/OS V11 BLOB and CLOB data values that are longer than 1,048,576 bytes.
This issue is fixed in the following cumulative update for Host Integration Server:
Note The Microsoft ADO.NET Provider for DB2 and the underlying Microsoft DRDA Application Requester Client for DB2 have been corrected to support data conversion for DB2 for z/OS V11 BLOB and CLOB data values that are longer than 1,048,576 bytes.
Learn about the terminology that Microsoft uses to describe software updates.
Keywords: kb, kbfix, kbqfe, kbHotfixAuto, CI100546