[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1325
  • Last Modified:

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.   ??
0
bergertime
Asked:
bergertime
  • 2
  • 2
  • 2
2 Solutions
 
Jon SnydermanCommented:
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.  

http://www-03.ibm.com/systems/i/software/db2/webquery/

~Jon
0
 
Gary PattersonVP 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. ($$$) http://www-03.ibm.com/systems/i/software/db2/webquery/

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 (http://squirrel-sql.sourceforge.net/), the exxcellent commercial tool AquaData Studio (http://www.aquafold.com/)

- Gary Patterson
0
 
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.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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

Thanks!
0
 
Gary PattersonVP Technology / Senior Consultant Commented:
Haven't used IB mobilefaves.
0
 
bergertimeAuthor Commented:
Thank you. :)
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now