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.

Answer Posted / divya,roshini,tiny

use scrollable cursor for fetching the 10th row

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the number of rows in db2 tables?

817


What is the maximum number of columns in a db2 table?

997


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2153


What is buffer pool in the db2 database?

849


What is universal database?

842


What kind of database is db2?

783


What is buffer pool?

852


List down the data types in the db2 database.

818


what is db2 restart?

1908


What language is db2 written in?

792


When the like statement is used?

892


What is db2 purescale?

764


what is utility for parm lib

2104


How can the duplicate values be eliminated from db2 select?

867


When reorg is used?

866