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 bufferpool in db2?

826

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11409

Define sqlca.

877

How do you eliminate duplicate values in db2?

929

How do I connect my db2 database to ibm?

817

How to retrieve rows from a db2 table in embedded sql?

1025

What is runstats db2?

792

How do I delete a column in db2?

889

What are the different types of base tables?

795

What is null indicator in db2?

875

How do I import data from excel to db2?

852

define clustering index.

824

What is plan in cobol db2?

818

What is a trigger in the db2 database?

837

What is nvl in db2?

845