Regd JDBS Statement...

Greenhorn

Posts: 17

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
I have a query which returns 10,000 rows and it takes lot of time to return.so is there any way in java while calling statement.executeQuery that i can mention get only 60 rows...
Thanks.
Senthil

Pat Wallwork

Ranch Hand

Posts: 72

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

In your SQL statement just say limit 60

this limits the results returned to the first 60 for your query
-Pat

senthil nathan

Greenhorn

Posts: 17

posted 19 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm working in DB2 database...this is not possible....
Any other suggestion...
Thanks
Senthil

Don't get me started about those stupid light bulbs.