how to get the serial number from a result 1

[123Hai]

Hi , I would like to get the serial numbers of the rows fetched from a query like
select * from table1;

slno field1 field2...
------------------------------
1 abc jjj
2 def kji
3 ghi ....
4....


If I get this from db2 ,I neednot have to a temp counter in the jsp or java pgm when i show the report....

Regards,
Sriram

 

[MarcLodge]

Hi Sriram,
hat you probably want is ROWID. This is not available in all versions of DB2, so you'll have to try it and see.

You can find out a little more in thread178-307573

Hope this helps
Marc

 

[123Hai]

Hi,
Happy New Year!.. I think interpretation of the question is bit wrong. What i want is continuous sl numbers for the result set , not the stored row id. I can have a query which joins 2 or more tables also . But the results should have serial numbers like 1 , 2,3.. which we can directly display in the report.

In short we get the number of rows selected after each query in any DBMS. Eg. 10rows affected.
I want each row to be numbered as 1, 2, 3 and so on...

How to get this?

Regards,
Sriram

 

[MarcLodge]

Hi Sriram,
I think that what you are after is the ROWNUMBER() function which is part of OLAP.

Have a look at :

http://dbforums.com/archives/t106989.html

Hope this helps.

Marc