Query/400 replacement needed

415 pts.
Tags:
AS/400
AS/400 Query
I need to get serious about finding a replacement for Query/400 on our 9407/515. At first glance, there seems to be a variety of packages available from IBM and third parties, most of them much more capable and more complicated than Query/400. Unfortunately, I am not expected to spend any more of my time supporting the new tool than I do Query/400, and we don't really need features that go very far beyond Query/400. So, can anyone suggest candidate tools that emphasize simplicity and ease of support (rather than sophistication and power)? Thanks in advance for any guidance. Regards, Steve B

Answer Wiki

Thanks. We'll let you know when a new response is added.

I have pretty much moved all our old query stuff to SQL views and/or embeded SQL statements. Does require some SQL basics, but very flexible and usually faster than Query/400.
IBM dos have its replacement, Web Query – but it does some some metadata that needs setup. Most old query jobs can convert over without much trouble. Does have some licensing issues to deal with.

Discuss This Question: 14  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gilly400
    Hi, What do you currently use Query/400 for and how do you intend to use it's replacement? Regards, Martin Gilbert.
    23,730 pointsBadges:
    report
  • SBatSI
    Martin - Thanks for your reply. 95% of our current usage of Query/400 is to allow end users to run prepared queries; some are run each time as is, some need to have selection criteria specified on each run, and some need to have selection criteria and page titles specified on each run. The other 5% of usage involves techies or power users running ad hoc queries to address a specific business situation or to troubleshoot a database problem. We anticipate pretty much the same usage of the replacement tool. Regards, Steve B
    415 pointsBadges:
    report
  • Cwc
    Not sure why you're looking to replace Query/400 if you're not looking for anything that offers much more than it does? I figure if you're going through the effort, why not something that blows it away (such as the aforementioned Web Query). Otherwise, if you want something basic, isn't Query/400 already pretty basic? I do recall a product called Sequel from Advanced Systems Concepts, which was a bit more flexible than Query/400. I think ASC has been bought since then, but I wonder if the product or its modern variant is still around.
    4,290 pointsBadges:
    report
  • SBatSI
    Cwc - Thanks for your reply. Why, you ask? Because (1) it is clear that IBM has put Query/400 on the path to extinction and (2) there are a modest number of things we would like to do that cannot be done at all or cannot be done easily with Query/400. We are in the same situation as the guy with a Honda Civic who gets married and needs a larger car; there is no reason to purchase a Hummer if a Subaru Outback will do. It wastes both time and money to purchase a package that is more sophisticated than we need; the license and support fees will be greater than necessary, and it will take extra time to support the product and fix it when it breaks. Yes, I remember Sequel as well, but Google searches have not revealed a lot about its current status. Regards, Steve B
    415 pointsBadges:
    report
  • Cwc
    Okay, thanks for clarifying. I like your car analogy. Take a look at this -- looks like Sequel ended up at Help Systems, perhaps it's worth investigating. http://www.helpsystems.com/intel/special.html
    4,290 pointsBadges:
    report
  • SBatSI
    Thanks for the link... I will follow up. Regards, Steve B
    415 pointsBadges:
    report
  • Lovemyi
    The nice part of ataying with the IBM Web Query replacement is that most of your Query/400 queries migrate over to the new web product with no problems. The bad part is that on a model 515 you only get a few development licenses for names users I believe. You can go the IBM website for System i and search for WebQuery for the license numbers. There are trade offs with this approach but if managed it should not be a big deal and it sould be $0 additional cost unless you need to add more named developers than the limit.
    2,310 pointsBadges:
    report
  • Cwc
    I ran across this the other day. Here's a pretty humourous look at Web Query, by Randall Munson, quite the comedian. http://www.ngsi.com/company/our_menu_has_changed.html And another: http://www.ngsi.com/company/elevator_act1.html Apparently, New Generation Software has something better - Qport Office http://www.ngsi.com/company/query400replacement.html http://www.ngsi.com/company/qportoffice.html
    4,290 pointsBadges:
    report
  • SBatSI
    When you start investigating DB2 Web Query, there are indeed lots of issues relating to licensing, support, and cost; it is an example of what I meant when I originally stated that most of the proposed Query/400 replacements are significantly more capable and more complicated - as well as more expensive. By the way, this description fits NGS-IQ as well, and a person could probably put together a pretty funny video about it too, perhaps delving into the issue of why, if the product is so easy to set up and use (as they claim), NGS REQUIRES you to purchase two training classes along with the license. That's pretty funny to me... ;-} I am now researching DataQuant from IBM; does anyone have any experience with it? IBM is not giving it away, but the price is reasonable and includes everything you need, rather than having to pay $x for this feature, $y for that feature,... and so on. There are still complications to deal with - after a few hours of work, I have still been unable to get the software to connect to the i5 because of some problem with the JDBC driver. Regards, Steve B
    415 pointsBadges:
    report
  • Shanse3
    You might want to check out m-Power. From what you described, m-Power could handle everything you currently use Query/400 for. Here's the product page: http://www.mrc-productivity.com/products/ Disclaimer: I work for mrc, the company that sells m-Power. So, I'm a little biased when I say it is a great tool, but it's definitely something you should check out if you're looking to replace Query/400.
    10 pointsBadges:
    report
  • SBatSI
    I looked into this perhaps a year ago, and I was quoted a licensing fee that would stun a horse. Perhaps the product is worth that amount of money to someone who is going to use it to do all the things it is capable of, but again, all I need is something that is modestly more capable than Query/400.
    415 pointsBadges:
    report
  • WoodEngineer
    We have used Interactive Query from New Generation Software for many years with great success. This is their bread and butter product so you don' t have to worry about it being headed for extinction. Also, the product was developed very closely with IBM so it works well. One feature our folks like is the ability to output query results directly to Excel without requiring any manual processes. It just runs the query, launches Excel and populates the cells. All of the standard stuff is there plus much more. They also have a very nice method for accepting run-time selection with prompting. This has saved us from having to develop multiple queries that only have different record selection. They also have an excellent support staff. I do not work for New Generation Software . . . just a very satisfied user of 20 years.
    6,875 pointsBadges:
    report
  • TomLiotta
    it is clear that IBM has put Query/400 on the path to extinction... This has been obvious for the past 15 years or so. Why be concerned now? In any case, have you reviewed the capabilities of Query Manager? (If you have SQL, you already have the QM product.) Any of your users who create queries should quickly adapt to the "Prompted" mode, since it's similar to Query/400. Other users who've seen SQL may prefer the "SQL" mode. All of them could take advantage of QM Forms to create custom reports that go well beyond Query/400's capabilities. If you haven't looked into it, you should study the user manuals to get a full picture of what it can do. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    BTW, QM has been IBM's preferred query product over Query/400 for the past 15 years or so. It's why Query/400 has been effectively dead for so long, though people keep paying for Query/400 for some reason even when they have QM. And QM can run Query/400 queries, so they don't need to be lost. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following