Symptoms

ADO.NET provider for DB2 doesn't process SELECT statement with duplicate named parameters within WHERE clause, and returns the following error:

SQLSTATE 07001, SQLCODE -313 

The number of host variables specified is not equal to the number of parameter markers.

Cause

ADO.NET provider for DB2 doesn't support processing the duplicate named parameter in multiple positions within a parameterized SELECT WHERE statement as shown below:

SELECT * FROM TABLE WHERE COL1 = @P1 AND COL2 = @P1.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Resolution

This issue is fixed in the following cumulative update for Host Integration Server:

References

Learn about the terminology that Microsoft uses to describe software updates.

Precisa de mais ajuda?

Expanda suas habilidades
Explore o treinamento
Obtenha novos recursos primeiro
Ingressar no Microsoft Insider

Essas informações foram úteis?

O que afetou sua experiência?

Obrigado pelos seus comentários!

×