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 / andyb
Why?
How do you know the one you want is still the 10th row ?
Other updates may have taken place.
If you know the key for the record you want then use that
Otherrwise unless the table has a sequential numeric key
then I think you have to go through the rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a dbrm in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the difference between nvl and coalesce?
What is a db2 package?
What is copy pending and check pending in db2?
How to get the ddl of a table in db2?
What is the result of open cursor statement?
What is performance tuning db2?
define clustering index.
How do I import a csv file into db2?
What is the difference between db2 and oracle?
When do you specify the isolation level?
Explain packages.
List out the buffer pools in db2
What are the contents of a dclmgen?