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

[Tom Ware <tom.ware@xxxxxxxxxx>]

Did you do any cleanup on the SQL?  EclipseLink will not send include "*" in its 
SQL.

How is your MonEntity mapped?  How exactly are you sending your query?

-Tom

On 27/02/2012 4:53 AM, Lexuor76 wrote:
> Hi,
> I followed your instructions. EclipseLink make this request :
>
> SELECT * FROM (SELECT * FROM (SELECT EL_TEMP.*, ROWNUMBER() OVER() AS
> EL_ROWNM FROM (SELECT OFNOFF AS a1, CMIACP AS a2, OFADF1 AS a3, OFADF2 AS
> a4, OFADF3 AS a5, OFADF0 AS a6, OFCPOF AS a7, CMIFAC AS a8, OFCCOM AS a9,
> OFDCRE AS a10, CLCCLI AS a11, CLMDIR AS a12, OFADL1 AS a13, OFADL2 AS a14,
> OFADL3 AS a15, OFADL0 AS a16, OFCPOL AS a17, CMMACO AS a18, CMIACO AS a19,
> CMMACV AS a20, CMPACO AS a21, CMIFRI AS a22, CMLFRI AS a23, CMNOFF AS a24,
> OFDEMI AS a25, OFINAT AS a26, OFTHTA AS a27, OFTTCV AS a28, OFTHTV AS a29,
> OFLOFF AS a30 FROM INCMDE ORDER BY OFNOFF ASC) AS EL_TEMP) AS EL_TEMP2 WHERE
> EL_ROWNM<= ?) AS EL_TEMP3 WHERE EL_ROWNM
>
> Sorry for simple paste but it's to complicated request for me.