Symptoms
When you run a parameterized query by using the Managed Provider for DB2 that is included in Microsoft Host Integration Server 2013, the query may fail, and you receive the following error message:
SQLCODE -290, invalid description
Cause
This problem may occur when you are using named parameters and use one of the named parameters two times in your query. The following code sample shows this problem:
cm.CommandText = "SELECT * from TABLE WHERE COL1 = @COL and COL2 = @COL";cm.Parameters.AddWithValue("@COL", "AAA");
Resolution
Cumulative update information
The fix that resolves this problem is included in Cumulative Update 1 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.
