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

What is reorg and runstats in db2?

1217

What is bind and rebind in db2?

1135

What is a page in db2?

1025

can we view the access paths created by dbrm ? how ? thx

7091

What are db2 tables?

1124

Outputs of explain are with matchcols = 0. What does this signify?

1054

What is db2?

1179

How to execute stored procedures?

1130

What is cursor with hold option in db2?

1069

What is a buffer in memory?

1058

How do you eliminate duplicate values in db2?

1186

Which are the db2 tools to protect integrity of the database?

1120

What is the syntax for seeing the columns and data types of a table in the db2 database?

1165

How to get the ddl of a table in db2?

1128

How do I import data from excel to db2?

1071