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

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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>

↑ Back to the top

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.

↑ Back to the top