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 / divya,roshini,tiny
use scrollable cursor for fetching the 10th row
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Where can you declare a cursor in a cobol-db2 program?
What are the various data types available in db2?
What is explain in db2?
Explain about rct in db2?
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 are packages in db2?
Define db2 and its databases?
What's The Percentage Free Space ?
What is a db2 collection?
What is copy pending status in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is sqlca’s maximum length?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How can deadlocks be resolved?
what is the sqlcode -501