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.
- 5 Answers
- 8803 Views
- I also Faced
- E-Mail Answers
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
Is db2 free?
What is load replace in db2?
How to find schema of a table in db2?
Name the lockable units in DB2?
What is the role of union all and union
Explain package in db2 and its advantages?
What are host variables in db2?
What is drop table?
Why do we bind in db2?
Mention data types used in db2 ?
What are the contents of a dclmgen?
What is db2 instance?
What is database reorganization?
i want to maintain uniqueness on pdf without make lf??????????
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
