Some column names aren't displayed when you use the Microsoft BizTalk Adapter for DB2 Schema Generation Wizard

Symptoms
When you use the Microsoft BizTalk Adapter for DB2 and Visual Studio Schema Generation Wizard, the column names of the selected table aren't displayed.

Note This issue occurs only if you created a DB2 table by using a mixed-case table name such as "MixedCaseTable."

Even if you change the generated XML file to match the mixed-case table name, the Biztalk Adapter for DB2 does not find the table.
Cause
The Biztalk Adapter for DB2 Schema Generation Wizard submits a select_tables schema call and converts all returned table names to uppercase.
This also occurs for the table name of the input XML file.
More information
After you apply cumulative update package 3 for Microsoft Host Integration Server 2013, you have to add the new property isMixedTableName to the <Sync> element of the XML file. This is a Boolean property.

If the property is set to "True," the table name will be used as is. However, if the property is set to "false" or is not present, the table name will be converted to uppercase. See the following example of how to set this property:

<ns0:DB2Request xmlns:ns0="DB2Test">
<sync nullvalue="IsNULL" isMixedTableName="true">
<after>
<MixedCaseTable COL1="10" COL2="COL2_1" />
</after>
</sync>
</ns0:Req>
Resolution
The fix for this problem is included in cumulative update package 3 for Host Integration Server 2013. For more information about how to get the cumulative update package, see Cumulative update package 3 for Host Integration Server 2013.
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 3068785 - Last Review: 09/23/2015 15:36:00 - Revision: 2.0

Microsoft Host Integration Server 2013

  • kbqfe kbsurveynew KB3068785
Feedback