Hi Folks,

We use JDBC to connect to a DB2 database on an AS/400. We wrote a
crude query tool that allows us to send SQL to the DB and get results,
but it doesn't have any convenience features like field selection etc.

Is there a query tool for DB2/400 similar to Query Analyzer for SQL
server? I know that there is an IBM Client Access package that can be
installed on a Windows workstation that provides some connectivity and
probably contains some type of query tool, but my experience with it
is that it is pretty invasive and caused conflict with other software
packages.

If someone is aware of a good tool with a small footprint (pure Java
would be awesome), I'd appreciate the tip!

Thanks,
Bob

On 5 Feb 2004 12:17:31 -0800, reefer_shark2001@yahoo.com (Bob
McDermott) wrote:
[color=blue]
>Hi Folks,
>
>We use JDBC to connect to a DB2 database on an AS/400. We wrote a
>crude query tool that allows us to send SQL to the DB and get results,
>but it doesn't have any convenience features like field selection etc.
>
>Is there a query tool for DB2/400 similar to Query Analyzer for SQL
>server? I know that there is an IBM Client Access package that can be
>installed on a Windows workstation that provides some connectivity and
>probably contains some type of query tool, but my experience with it
>is that it is pretty invasive and caused conflict with other software
>packages.
>
>If someone is aware of a good tool with a small footprint (pure Java
>would be awesome), I'd appreciate the tip![/color]

If you have MS-Access, just link the tables through ODBC. You'll have
to install the client access software on the client, though.


--
Bob Hairgrove
NoSpamPlease@Home.com

Might want to look at the QMF for Windows for iSeries offering - it doesn't
require the iSeries Access middleware.

--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, iSeries
kmill@us.eye-bee-m.com (spam trick) GO HAWKEYES!![color=blue][color=green][color=darkred]
>>> www.iseries.ibm.com/db2[/color][/color][/color]
(opinions stated are not necessarily those of my employer)

StarQuest has a good JDBC driver for DB2, www.starquest.com

Bob

reefer_shark2001@yahoo.com (Bob McDermott) wrote in message news:<f61c9c39.0402051217.5650235c@posting.google. com>...[color=blue]
> Hi Folks,
>
> We use JDBC to connect to a DB2 database on an AS/400. We wrote a
> crude query tool that allows us to send SQL to the DB and get results,
> but it doesn't have any convenience features like field selection etc.
>
> Is there a query tool for DB2/400 similar to Query Analyzer for SQL
> server? I know that there is an IBM Client Access package that can be
> installed on a Windows workstation that provides some connectivity and
> probably contains some type of query tool, but my experience with it
> is that it is pretty invasive and caused conflict with other software
> packages.
>
> If someone is aware of a good tool with a small footprint (pure Java
> would be awesome), I'd appreciate the tip!
>
> Thanks,
> Bob[/color]