RE: Query400 for WebSphere iSeries

Paul, does that utility work on other databases besides DB2 on an iSeries? -
like MySQL for instance?  Is it as simple as having a compliant jar file?

Thanks,
Aaron Bartell 

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx [mailto:java400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Paul Holm
Sent: Monday, September 19, 2005 1:09 PM
To: java400-l@xxxxxxxxxxxx
Subject: Query400 for WebSphere iSeries




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.  
>
 

--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.1/104 - Release Date: 9/16/2005