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 .
In Oracle using rowid we can get the records dynamically where as in
DB2 is the facility is there or not ?
Give some guidance regarding my requirement.
> 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.

Signature
Knut Stolze
DB2 Information Integration Development
IBM Germany