iSeries Query Designer

Posted on 2012-08-27
Last Modified: 2012-08-29
We have an iSeries version on  os 7.1.  I need to know if there is a query designer?  Like the one from SQL server mgmt studio.  I can use the one in iSeries Navigator, but it's cumbersome, I've linked it to my SQL Server 2008 R2, but the query builder dosen't work on it.  I can see the data, just can't build a query.  So right now I use three different ways to get ad hoc queries out of it.  I can build them in the green screens, build them using Navigator, or, since I'm usually in visual studio add a sqlDataSource and build it that way.  There has to be a decent gui Query Designer for the 400.   ??
Question by:bergertime
    LVL 6

    Accepted Solution

    DB2 Web Query is the successor to Query.  The current version (1.1.2) has an amazing query builder based on Information Builders.   Based on your OS licenses, you have a certain number of licenses already.

    LVL 34

    Assisted Solution

    by:Gary Patterson
    1) Green-screen SQL query tool with prompt support (not a GUI): STRSQL.  Free if the SQL Developers Kit is installed on your system.

    2) Navigator's RUN SQL Script utility,  Free if you install IBM i Access.  Sounds like you've seen this and are looking for something a little more sophisticated.

    3) The "IBM solution" is DB2 Web Query - Sophisticated web-based query designer, scheduler, and runtime environment.  Available under license from IBM. ($$$)

    4) Since JDBC, ODBC, OLE DB, and ADO.NET drivers are all available for IBM i (AS/400, iSeries), you can use ANY query tool that that you like that supports these interfaces, probably including the one in SQL Server Mgmt Studio, open-source Squirrel SQL (, the exxcellent commercial tool AquaData Studio (

    - Gary Patterson
    LVL 2

    Author Comment

    Wow.  Webquery rocks!  And we already have a license.  Just FYI, the latest version is 2.1  and from what I understand it is vastly better than 1.1.2.  

    I did try squirrel, couldn't get it to work.  Tried aquafold and it was very nice.

    On additional question if I might.  Have either of you used the IB MobileFaves?  It's a native app for iOS built by the same people who built Web Query, but for the life of me I can't get it to connect and info seems to be lacking.  Anyway, thanks again, if I don't hear anything else I'll award points tomorrow.
    LVL 6

    Expert Comment

    by:Jon Snyderman
    I havent used that.  It sounds cool.  Glad to hear that you liked WebQuery.  I really liked it also, and that was at 1.1.1 which was no where near 1.1.2 and apparently 2.1.   Now you have me anxious to try 2.1 :)  

    LVL 34

    Expert Comment

    by:Gary Patterson
    Haven't used IB mobilefaves.
    LVL 2

    Author Closing Comment

    Thank you. :)

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    Connect SQL Developer to zO/S DB2 database 6 143
    iSeries PERL Scripts 7 117
    DB2 error. 37 60
    iSeries DB2 Query 2 69
    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 (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    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…

    755 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

    19 Experts available now in Live!

    Get 1:1 Help Now