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 / m4io
DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...
FETCH ABSOLUTE 10 FROM cursor_name
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain about dbrm.
How will you return the number of records in table?
How do I copy a table in db2?
Explain the contention situations caused by locks?
What is the maximum size of a char data type in db2?
What is the information associated with sysibm.syslinks table?
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
How to resolve deadlock issue
Describe major components of db2?
Explain the function done by data manager?
What is cascading rollback?
Can there be more than one cursor open for any program?
List out the data types available.
What is rct?
Mention data types used in db2 ?