DECLARE cursor_name sensitivity SCROLL CURSOR FOR SELECT ... FROM ...

I want to fetch the 10th row of a table which has been
changed.How can I do it without going thru all the rows.

Question Posted / m4io

Answer Posted / m4io

DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...

FETCH ABSOLUTE 10 FROM cursor_name

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When reorg is used?

1082

List out the buffer pools in db2

1028

How can the duplicate values be eliminated from db2 select?

1050

What is the difference between using bind () and rebind () methods of naming class?

1341

What are catalog tables in db2?

998

What does db2 mean?

963

What is the difference between drop table and delete table?

1134

What is database reorganization?

1068

What does reorg do in db2?

990

What is a db2 tablespace?

1009

How to connect to db2 database from windows command line?

1011

What is a trigger in the db2 database?

1026

Explain various types of locks in db2?

1096

What is dpf in db2?

1062

How to rename a table in DB2 ?

1038