Windows query tool for DB2/400

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Bob McDermott
    #1

    Windows query tool for DB2/400

    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
    Tags: None
    • Bob Hairgrove
      #2
      Re: Windows query tool for DB2/400

      On 5 Feb 2004 12:17:31 -0800, reefer_shark200 1@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@Ho me.com

        Comment

        • Kent Milligan
          #3
          Re: Windows query tool for DB2/400


          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)

            Comment

            • DB2
              #4
              Re: Windows query tool for DB2/400

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

              Bob

              reefer_shark200 1@yahoo.com (Bob McDermott) wrote in message news:<f61c9c39. 0402051217.5650 235c@posting.go ogle.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]

                Comment

                Previous template Next
                Working...