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 the max length of sqlca?
What is nvl in db2?
How do I connect my db2 database to ibm?
How to take backup of table in db2?
Explain about rct.
Can one database have multiple instances?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is clone table?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What happens in bind step in a db2 program?
can all users have the privilage to use the sql statement select * (dml)?
What is drop table?
How to check last update on table in db2?
What is universal database?