Answer Posted / vaneeshh khurana
See there is no direct method to do so, but still if we want
last 5 rows only we can create a logic which is as follows.
1. Declare an array to save the fetch rows with occurs of 5.
2. Now fetch the rows and start saving in that array such
that when the count becomes 5 overwrite the 6th fetch in the
first occurs similarly the 7th fetch on the 2nd occur.
3. Now when all the fetching is done the array will contains
the last 5 fetched rows.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain about rct.
What is runstats utility in db2?
What is db2 bind process?
What is the difference between db2 and oracle?
What is dbrm library?
What happens in bind step in a db2 program?
What is sqlca?
Define db2 and its databases?
What are the full forms of spufi and dclgen and why are they used?
What are the contents of a dclmgen?
What are the rules for db2 programming?
How can you quickly find out the # of rows updated after an update statement?
What is load utility in db2?
What is the use of value function?
How to run db2 command in windows?
