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!
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 is the meaning concurrency in the db2 database?
is it compulsory commitment control in journal?
What is runstats utility in db2?
Give the name of some fields form sqlca.
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Is db2 a database?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Which components manage deadlocks in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What are db2 tables?
Mention data types used in db2 ?
What is database manager in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Is db2 a mainframe?