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

Explain db2.

608


How many types of page locks can be held in db2?

589


What does reorg do in db2?

573


Which component is responsible for db2 startup and shutdown?

622


What is concurrency?

707






How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1707


What is reorg?

615


What is consistency token in db2?

636


How do we specify index to include or not during bind process.

1674


What is copy pending and check pending in db2?

570


What is database alias db2?

595


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

784


How to connect to db2 database from windows command line?

560


Define check constraint.

642


What are the different types of base tables?

583