iSeries Query Designer

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.   ??
Who is Participating?
Jon SnydermanConnect With a Mentor Commented:
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.

Gary PattersonConnect With a Mentor VP Technology / Senior Consultant Commented:
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
bergertimeAuthor Commented:
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.
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Jon SnydermanCommented:
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 :)  

Gary PattersonVP Technology / Senior Consultant Commented:
Haven't used IB mobilefaves.
bergertimeAuthor Commented:
Thank you. :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.