Re: SQL Question -Paging

Paul,
   How do I get the free utility ?

Best regards,

Vengoal

Paul Holm wrote:

Larry,

In terms of SQL paging, the AS400 JDBC driver won't read the entire results.
It can be controlled by the "block size (specified on JDBC connection
props)" and the number of times you iterate over your resultSet.next().  So
what we do is read a set of records based on how many records the user wants
at a time, return that set and then allow them to request more.  Once they
want more we then return the 2nd set of records and so on.  Tricks are to
control if you should hold the connection between requests, block size, and
retain memory of where each user is in terms of the paging  (user x is on

records 300-350 of query x).

Here is an example:

http://www.planetjavainc.com/wow63x/runApp?id=369&_pj_lib=wowsamp60

Under "JDBC Statement Controls" you can set the sql statement, row count,
and label.  Change the values then click "update sql" and then run that sql

using "JDBC Statement". This is part of a free utility we offer if you need this function. HTH

Paul Holm

www.gotwebdata.net iSeries Web Apps in 30 seconds pholm@xxxxxxxxxxxxxxxxx