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

what is db2 restart?

1931


Is it possible to create an Instance in DB2 using DB2 Control Center ?

870


Give the name of some fields form sqlca.

851


What parameters are used to control the free space in DB2?

860


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

407


What is dbrm in db2 database?

818


What is a storage group (stogroup)?

1013


Explain the contents that are a part of dclgen.

895


How do you find the maximum value in a column in db2?

866


What is coalesce in db2?

887


What is sqlca?

845


What is db2 connect?

833


What is host variable?

839


How does db2 sample database connect?

804


How can we read records for specific member in CL? AND rpg?

484