Re: SQL - ROWNUM

If you really don't care about row number, for example, you only want the 
first 100 rows of
select cola, colb, colc
from mytable 
order by colb
where cola is not null

then you simply change that to
select cola, colb, colc
from mytable 
order by colb
where cola is not null
fetch first 100 rows only

There's also RRN and RID, which are the same thing and can be found here:
http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/db2/rbafzscale.htm?lang=en-us
But that's not what you want.

There's also some way to return an auto incrementing counter like
select 
(...), cola, colb, colc
from my table
order by colb
where cola is not null
and it would return something like
1, B, 2, 3
2, A, 65, 1
3, D, 72, 2
4, C, 101, 4
where the first column automatically increments but it's slipping my mind. 


Rob Berendt