After upgrading to DB2 v9.7 FP5 and using the DB2 .NET Entity
provider with the Microsoft Visual Studio Entity Framework
Modeller - Linq Data Source, and exception can occur as follows:
[NotSupportedException: The connected server doesn't support
"Top" expression.]
IBM.Data.DB2.Entity.SqlGenerator.Visit(DbLimitExpression e) +196
System.Data.Common.CommandTrees.DbLimitExpression.Accept(DbExpre
ssionVisitor`1 visitor) +20
IBM.Data.DB2.Entity.SqlGenerator.a(DbExpression A_0, String A_1,
TypeUsage A_2, Symbol& A_3) +86
IBM.Data.DB2.Entity.SqlGenerator.Visit(DbProjectExpression e)
+162
System.Data.Common.CommandTrees.DbProjectExpression.Accept(DbExp
ressionVisitor`1 visitor) +20
IBM.Data.DB2.Entity.SqlGenerator.a(DbExpression A_0, Boolean
A_1) +148
IBM.Data.DB2.Entity.SqlGenerator.b(DbExpression A_0) +45
IBM.Data.DB2.Entity.SqlGenerator.a(DbQueryCommandTree A_0,
Hashtable& A_1, ArrayList& A_2, String[]& A_3) +491
IBM.Data.DB2.Entity.SqlGenerator.GenerateSql(DbCommandTree tree,
DB2ProviderManifest manifest, List`1& parameters, CommandType&
commandType, Hashtable&
IBM.Data.DB2.Entity.DB2ProviderServices.a(DbProviderManifest
A_0, DbCommandTree A_1) +491
IBM.Data.DB2.Entity.DB2ProviderServices.CreateDbCommandDefinitio
n(DbProviderManifest manifest, DbCommandTree commandTree) +132
System.Data.Common.DbProviderServices.CreateCommandDefinition(Db
CommandTree commandTree) +84
System.Data.EntityClient.EntityCommandDefinition..ctor(DbProvide
rFactory storeProviderFactory, DbCommandTree commandTree) +333 |
****************************************************************
* USERS AFFECTED: *
* Windows users, using DB2 .NET *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1, Fixpak 1 *
**************************************************************** |
