FW: Query400 for WebSphere iSeries

Aaron,  

Yes, it supports Oracle, MySQL, Postgres, DB2, DB2 iSeries, SQL SERVER,
EXCEL, and JDBC-ODBC bridge.  

You simply select the driver and enter the IP. All the needed jars are
packaged with it.  

The framework/utility handles all databases virtually the same powered by
metadata for UI generation, prompting, subfiling, etc.    

To see an example:  Check this out:

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

Go to the JDBC statement control menu then to "SQL statements".  From there,
you can change the subfile # of records, menu item label, and SQL  (based on
standard iSeries QIWS/QCUSTCDT file).  Changing the SQL or any config data
will be immediately reflected in the JDBC statements menu items.  
For dynamic prompting, change the SQL to something like:  "select * from
qiws.qcustcdt where state = ?  "

Param marker used for dynamic user selection.  

P.S.  The last time we talked, I recall we were in New Orleans for DevCon.
How that area has changed since that huh?  Also I need you to straighten out
the Vikings if you would please.  8 picks in two games?

Hope you're doing well.  

Paul Holm





-----Original Message-----
From: Paul Holm [mailto:pholm@xxxxxxxxxxxxxxxxx] 
Sent: Tuesday, September 20, 2005 2:14 PM
To: 'java400-l@xxxxxxxxxxxx'
Subject: RE: Query400 for WebSphere iSeries


Mon, 19 Sep 2005 14:31:03 -0500
from: "albartell" <albartell@xxxxxxxxx>
subject: 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