how can get the fields under result set db2 generated schema in BizTalk Server2013 RRS feed

  • Question

  • I'm utilizing the DB2 adapter in Biztalk 2010 to query data in a DB2 database on an iSeries machine.  It's working very well and the results of the query are correct.  The issue I'm having is that, I'm not at all sure how to utilize the results.  The issue is that all of the rows returned are placed into a node called "ResultSets" of type "anyType".  How do I get the rows from this "anyType" node out to work with (e.g. place into another message in an orchestration)?  Thank you in advance for any help.

    Wednesday, March 27, 2013 7:00 PM


  • Hi Srini,

    You can use Map convert to your expected format by using xslt instead of direct/functoid mapping.

    We wont get the schema with the expected format as we are getting for SQL schema, so we need to go with the conversion using map with custom xslt.

    Create a Custom xslt and refer the same in the map,  then you can use the values fetched from the DB2 in orchestration.

    Regards, Aboorva Raja R

    Tuesday, April 2, 2013 9:39 AM

All replies