File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Regd JDBS Statement...

 
senthil nathan
Greenhorn
Posts: 17
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm working in DB2 database...this is not possible....
Any other suggestion...
Thanks
Senthil
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic