开发者

BizTalk 2009 DB2 HIS Adapter

开发者 https://www.devze.com 2022-12-11 03:48 出处:网络
When using the mainframe DB2 adapter for Microsoft BizTalk 2009, is there any way to get the ge开发者_开发技巧nerated schema to contain all the columns in the result set?

When using the mainframe DB2 adapter for Microsoft BizTalk 2009, is there any way to get the ge开发者_开发技巧nerated schema to contain all the columns in the result set?

We get a simple schema generated, the response contains a record/element called "ResultSets" with a data structure of 'xs:anyType'.

If I recall, this works okay in MS/SQL server stored procs (but memory is shakey - I think we had to change add the "for xml auto" to the select statement while doing the generate data).

Would any other adapter work? What about the new WCF/LOB adapters?


Here's another summary of this issue that I just found: http://www.novaenterprisesystems.com/Blog/category/Adapters.aspx


I posted that question in MSDN forum for HIS, and they said it doesn't do that. I think the DB2 interface is very un-baked and un-tested. You also have to set the response schema to "Unqualified", but seems like the request schema's "element form default?" has to be "qualified, thus resulting in two different schemas - i.e. you have to split the schema that they generate into two.

0

精彩评论

暂无评论...
验证码 换一张
取 消