Re: [eclipselink-users] Order By with DB2/400 DataBase

[Tom Ware <tom.ware@xxxxxxxxxx>]

You are probably right that there is a bug.  Please file a bug and supply the 
SQL you would expect to see generated.

You can override the way SQL is generated for queries with first and last 
results specified.  You will want to create a subclass of DB2MainframePlatform 
and tell EclipseLink to use that class using the eclipselink.target-database 
persistence unit property.

In that class you can override printSQLSelectStatement().  Take a look at the 
source for that method in DB2Platform.  You should be able to use that method 
and just alter it to do what you are hoping for.

-Tom

On 27/02/2012 10:19 AM, Lexuor76 wrote:
> After some search I saw the request generated by EclipseLink is false.
>
> The correct syntax should have the order by un OVER() function.
>
> I think this is a bug in EclipseLink.