narayana wrote:
I want the criteria like this.
I have 10k of rows in my table and i have to fetch first 200 rows . And
next time when i execute the same query it should fetch next 200 rows
and that should be continued .For that is there any query for my
requirement or I have to write a dynamic sql procedure for this .
You can use the row_number() OLAP function. Samples for that are posted
here frequently.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany