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

5 Answers
10775 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2067

What is db2 plan table?

1052

What are packages in db2?

1023

Explain db2.

1039

What is db2?

1184

How can we retrieve the total number of records in RPG & CLLE?

656

What is package in db2 mainframe?

989

Are view updateable?

1046

How do I import data from excel to db2?

1074

What are concurrency issues?

1097

What is the connection string to connect to the DB2 Database ?

1128

What are host variables in db2?

1072

What is difference between rollback and commit?

1164

Mention some fields that are a part of sqlca.

1034

What is node in db2?

1045