Answer / 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

Answer / mvramesh

How about combingin two queries with set operator EXCEPT,
if you have query A EXCEPT query B, the result would be A-B.

Select * from table A fetch first 200 rows only
Union except
Select * from table A fetch first 100 rows only

Answer / sudheer d

YA THE ANSWER IS BY USING CURSORS ONLY
declare
cursor USER_Cursor
is select *
from <table_name>;

y <TABLE_NAME>%ROWTYPE; --ITS A DATA TYPE INCLUDES
WHOLE ROW 4M A TABLE IN TO X
COUNT1 number(2);

begin
COUNT1:=1;
open USER_Cursor;

while USER_Cursor%FOUND AND COUNT1 <>101
loop
fetch USER_Cursor into y;-- JUST FETCH DONT DISPLY -
--TILL 101ST RECORD
COUNT1:=COUNT1+1;
end loop;

--NOW DISPLAY FROM 101 RECORD TO 200 RECORD
while USER_Cursor%FOUND AND COUNT1 <>201
loop
fetch USER_Cursor into y;
dbms_output.put_line(y);
COUNT1:=COUNT1+1;
end loop;

close USER_Cursor;
end;

Answer / vikatakavi08

select * from emp where rownum<=100 and rownum>=200;

Answer / sangeeta david

We can make use of Relative record number that is

Select * from Table A where RRN(A) between 100 and 200

Answer / mysterious

is it row number that u are looking for?

Answer / prasenjit

Yes and no in both ways.
I know there is a Roid() Over() function DB2 release 7
onwards and that shld solve the problem.
But what if there was condition that you cant use these
functions.
Cant there be any query that can produce the req result.

Answer / the boss

There is no correct answer to this flawed question.
In RDBMS theory a table doesn't have 'records'; it is an
UNORDERED set of tuples ("rows"), so there is no
recordnumber 100 or 200.

Answer / venkat

select * from table where empno > 100 or ( select * from
table where empno < 200)

Some many ways to write a query for this, this is one way...

Answer / rajeshkumar

SELECT * FROM TCB732D.AR_AR WHERE NUM_SEQ_AR IN(
SELECT NUM_SEQ_AR FROM TCB732D.AR_AR ORDER BY NUM_SEQ_AR
FETCH FIRST 200 ROWS ONLY)
ORDER BY NUM_SEQ_AR FETCH FIRST 100 ROWS ONLY

What is db2 bind?

0 Answers  

How do you run JCL in cobol program

1 Answers   IBM, Syntel,

is it compulsory commitment control in journal?

0 Answers   TCS,

Mention the downsides of page level lock.

0 Answers  

Which is faster delete or truncate?

0 Answers  

What is a collection in db2?

0 Answers  

How to find last record before record through SQLRPGLE?

1 Answers   IBM,

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

How we create a tables in db2,what is the process/syntax to create a table with example plz?

2 Answers  

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

What are column-name qualifiers used?

1 Answers  

What is syscat in db2?

0 Answers