Hello,

I wanna have something like a rownum for iseries DB2,
I mean, i need to have a function for being invoked in a Query like this:

Select rowfuncion, Id from A_Table

and i wanna have something like this :


1 Id_01
2 Id_45
3 Id_03
4 Id_50


How do I do it?

hi,

This is a example:

select RANK() OVER (ORDER BY <Your field> DESC) AS myRANK
from <your table>


abel.

No man,

That's not possible in Iseries

May be can explain to me, what version of db2 and OS-

In db2 UDB v.8.1.4 for windows this run ok, but, I unknow your system.

talk spanish?

Hello I'm trying to use rownumber in Linux and it works perfectly
with DB2 8.1 but id doesn't work in ISeries 5.2

En Español
En español como me lo solicitaste,

Primero que todo, gracias por tu interes, necesito utilizar el Rownumber o llevar una numeracion de los registros que retorna un query de una manera no muy costosa, en Iseries (sistema operativo) sobre el cual está DB2.

Es claro ahora ??

See the end of this thread...

http://www.dbforums.com/t990660.html

Thanks everybody !!!!