[ravi_zee]

Hi,
I have an INI file, contans a fiel with "RestrictedRead =100"
I am reading the INI file in my Java code and getting this restrictd value and building a query dynamically for further processsing as...

sSQL = sSQL + " TOP " + getRestrictReadValue() + " ";

PROBLEM

If I have 10000 records to be processed, as of now it is reading only 100 records.But I want after 100 records completed it should fetch next 100 and continue till EOF(10000) records...

Can anyone help me how to succeed this and how to form a query for this scenario.

Matter very urgent

Cheers
Ravi

[r123456]

I dont know the meaning of "TOP" in this context.

If you will retrive all records into a single result set then use the following method. However if you only want to return 100 per result set then the second option will work, although the first is clearly faster and more efficent.

From 1.4 -
"boolean absolute(int row)
Moves the cursor to the given row number in this ResultSet object"

This is ideal for your problem and its also faster than the SQL query, simply set row to row + limit.

Here is the SQL query alternative anyway,

The final row of ResultSet will contain the last rownum returned. Repeat this procedure until EOF is reached.

X = X + (rownum from final row) ' set X to 0 for first call
limit = 100

Query,

select columns
from
(
select *
from table
minus
select *
from table
where rownum <= X)
where rownum <= limit;

[r123456]

Update -
A solution to your problem using the ResultSet absolute method has been included in my previous reply. It's the efficent solution. If you do need to use multiple instances of ResultSet, then perhaps some PL/SQL in conjunction with a fast query.