looking replacement of runqry

Posted on 2006-03-24
Last Modified: 2008-02-01
I have an As/400 box and I am connecting thru TN5250 client

instead of using runqry I am looking for some gui tool ( like AQT) to connect to the db from my laptop and view the tables and data

thankyu for all ur help!!!!!!!!!!!!!!!!!!!!!!!!!!!
Question by:royalcyber
    LVL 7

    Accepted Solution

    connect using db2 connect and use script/control center.

    Author Comment

    any other third party or open source product ?
    LVL 32

    Expert Comment

    Crystal reports, Cognos are a possibility, basically any reporting tool with ODBC support will do.

    If you are an ms-office user, Try Excel with MS Query for the simplest solution.

    Author Comment

    but what does developers use normally for db2 on as/400 to view db, create new tables , updates etc

    for example I use AQT for db2 on AIX
    LVL 32

    Assisted Solution

    I think that AQT can be used with any ODBC database, including AS400.
    The AS400 runs a flavor of DB2 called DB2 UDB and the AS400 Client Access CD contains an ODBC driver.

    The as400 has a native tool called STRSQL that can be used for all of your database maintenance.

    Other common tools used by as400 developers are packed inside the Operations Navigator windows client - also found in Client Access CD - in the Database section.

    LVL 18

    Assisted Solution

    If you're going to use the AS400 as your back end, you NEED iSeries Navigator (aka Operations Navigator). It's installed with the Clent Access package, and it allows you to do what you're looking for.

    You can easily see table structures, run SQL, create and modify stored procedures, see the data, etc.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now