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 3 7059
On 5 Feb 2004 12:17:31 -0800, re************* *@yahoo.com (Bob
McDermott) wrote: 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!
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 No**********@Ho me.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 km***@us.eye-bee-m.com (spam trick) GO HAWKEYES!! www.iseries.ibm.com/db2
(opinions stated are not necessarily those of my employer)
StarQuest has a good JDBC driver for DB2, www.starquest.com
Bob re************* *@yahoo.com (Bob McDermott) wrote in message news:<f6******* *************** ****@posting.go ogle.com>... 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: shank |
last post by:
1) I'm getting this error: Syntax error (missing operator) in query
expression on the below statement. Can I get some advice.
2) I searched ASPFAQ and came up blank. Where can find the "rules" for when
and how to use single quotes and double quotes in ASP?
thanks!
----------------------
SQL = SQL & "WHERE '" &
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE("GenKTitles.
|
by: Olivier |
last post by:
Hi !
I've got a problem trying to figure out a query.
I have a table with following fields:
tool varchar(30)
last_date datetime
user_id mediumint(8)
....
|
by: Alex |
last post by:
Subject: Looking for an XML (database-based) Query Reporting
Tool/advice
First off, let me apologize if this thread is somewhat off topic...
PLEASE REPLY TO: xml@solex-bi.com
I am looking for a way to query XML documents stored in an Oracle 9i
database, contained in an unstructured CLOB column, much like one would
with a traditional BI query reporting tool, but using XPath or XQuery
|
by: Joakim Persson |
last post by:
Hello all. I am involved in a project where we have a desire to
improve our software testing tools, and I'm in charge of looking for
solutions regarding the logging of our software (originating from
embedded devices). Currently, we are using a heavyweight, proprietary
log tool developed by another part of the company. This tool contains
all "standard" logging functionality, but we also need to insert
"debug" log points in the software of...
|
by: Conner |
last post by:
Hi Bob,
I know this reply is a little late for you but I just came accross
your post. You might be interested to know that there is a pretty good
query tool available on download.com called Universal Table Browser.
It is a multi-database enterprise level query tool and I have been
able to open data sets that contain literally millions of records in a
matter of seconds with it.
| |
by: Donnie |
last post by:
Hello All
I am trying to find some information on how to design/develop a SQL Query tool embedded in an ASP.NET web application
What I would like to have is a tool that helps a user write SQL statements that are in turn used to query a database. The results of the query will then be displayed in a DataGrid. I'd like the tool to help the user write the query (similar to a Query By Example tool). I currently have a web app that allows a...
|
by: Donnie |
last post by:
Hello All
I am trying to find some information on how to design/develop a SQL Query tool embedded in an ASP.NET web application
What I would like to have is a tool that helps a user write SQL statements that are in turn used to query a database. The results of the query will then be displayed in a DataGrid. I'd like the tool to help the user write the query (similar to a Query By Example tool). I currently have a web app that allows a...
|
by: abighill |
last post by:
Problem
-------------
I want to return all URL records from 'fett_url' that are not currently
indexed in the lookup table 'fett_url_to_data' where 'data_id=2'.
i.e.
fields=> url_id, url_title, url_link, url_description
|
by: TF |
last post by:
This group came through for me last time so here we go again. My page
shows paint colors, brand name, product code, etc in a gridview with
the background matching the paint color. Several links on the page are
used to call itself with querystring values for brand, thinner,
finish, etc. The page must show all colors if the querystring is
empty and filter out records that don't match the querystring value
when it's not. I've tried building...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |