Symptoms
You run an application that uses the Managed Provider for DB2 that's included in Microsoft Host Integration Server 2013. When you try to pass a parameter that does not specify the MsDb2Type value or when an incorrect value is used, incorrect results are passed to the DB2 table.
Note For example, this problem occurs in the following code example:
Dim Test As Decimal = 12.1234
param.MsDb2Type = MsDb2Type.Int
param.Value = Test
MyCommand.Parameters.Add(param)
Note Even if an incorrect data type is specified by the Managed Provider for DB2, the value is passed to the DB2 table.
Cause
This problem occurs because the Managed Provider for DB2 does not perform validation regardless of whether a value is typed correctly or incorrectly. Nor does it prevent incorrect values from being passed to DB2.
Resolution
Cumulative update information
The fix that resolves this problem is included in Cumulative Update 2 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.
