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
What is difference between rollback and commit?
What is a Foreign Key?
What is a storage group (stogroup)?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
B37 abend during spufi?
What are the rules for db2 programming?
Explain the benefits you can get from mainframe connect?
How to view db2 table structure?
Is db2 relational database?
What language is db2 written in?
What is the role of data manager in the db2 database?
How can you classify the locks in db2?
What is a db2 package?
Before you give the explain statement, what are the prerogatives?
Explain in brief how does db2 determine what lock-size to use?