Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP!
- 17 Answers
- 27709 Views
- KNIT, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / m4io
scrollable cursors
------------------
DECLARE cursor_name sensitivity SCROLL CURSOR FOR
SELECT ... FROM ...
open cursor
FETCH ABSOLUTE 100 FROM cursor_name
do 100 times
FETCH NEXT FROM cursor_name
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What r the comman abends in db2, jcl and cobol???????
Mention the downsides of page level lock.
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is a dbrm in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How to create db2 table in mainframe?
What is a trigger in the db2 database?
What is the use of reorg in db2?
What db2 400?
Highlight all the advantages that are attached to a package.
What is db2 catalog database?
What is null indicator in cobol db2?
What is dbrm? What it contains? When it will be created?
What is the difference between using bind () and rebind () methods of naming class?
Can there be more than one cursor open for any program?
