Query400 for WebSphere iSeries

["Paul Holm" <pholm@xxxxxxxxxxxxxxxxx>]

Vengoal/All,  

You can get the free utility you mentioned by sending an email to
info@xxxxxxxxxxxxxxxxx  

Basically, the utility is like Query/400 for WebSphere or Tomcat.  It allows
you to select a library and table from the iSeries, then select the fields
you want in your report.  It then generates SQL/JDBC along with all related
user interface, sorting, and subfiling code.  For these basic inquiries, it
can save you lots of time.  Typically inquiry applications only take a few
seconds to complete.  You can download it or run it from our development
servers to take a look using this link.  

WOW Express Builder utility

http://www.planetjavainc.com/wow635/runApp?id=0&_pj_lib=WOWEX63


This is a sample application built with the utility.  

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


HTH,  Paul Holm





   3. Re: SQL Question -Paging (Vengoal Chang)
message: 3
date: Fri, 16 Sep 2005 10:31:33 +0800
from: Vengoal Chang <vengoal@xxxxxxxxxxx>
subject: 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.  
>