Hi,
I need to write a query which selects some columns from a table with a
Serial number being displayed along with the other data from the table

For eg:
SNO Doc#
1 xxxyy
2 abcd
3 xyz


This SNO should be made to increment in the query itself.
Its like a numbering for the rows displayed.

Olap functions:
row_number() over()

It is displaying the message
"The function ROW_NUMBER() not found"
Any other solution

What is the Version of DB2 you are using and what is the operating system?

The post above did not provide the exact syntax you need to use for the OLAP function. Please check the SQL Reference manual to see if it is supported on your version of DB2, and to see exactly how to use the OLAP function.

I am using DB2 verson 7

I am using DB2 verson 7

$ db2 "select ROW_NUMBER() over() Row_Count, DEPTNUMB, DEPTNAME from org"

ROW_COUNT DEPTNUMB DEPTNAME
-------------------- -------- --------------
1 10 Head Office
2 15 New England
3 20 Mid Atlantic
4 38 South Atlantic
5 42 Great Lakes
6 51 Plains
7 66 Pacific
8 84 Mountain

8 record(s) selected.

You did not state whether this is DB2 for z/OS or DB2 for Linux, UNIX, and Windows. Check the SQL Reference for your product to see if the row-number function is supported.