- You use the Microsoft BizTalk Adapter for DB2 to call IBM DB2 stored procedures.
- The IBM DB2 stored procedure issues a query that returns XML-formatted string data that is defined by using a DB2 data type of VARCHAR(32000). This is treated as a Character Large Object (CLOB) data type.
In this scenario, the result set that's returned by the IBM DB2 stored procedure is not passed to BizTalk Server application through the BizTalk Adapter for DB2. The final output of the BizTalk Server application (for example, an output file) contains a blank result set.
Article ID: 2973451 - Last Review: 3 Dec 2014 - Revision: 1