Re: 5722-QU1 Question - tools for query-style function ?

I have to say that Query/400 was a great tool. We had PC users uploading
their data to their AS400 just so they could use Query/400 against it.
Executives usually had no trouble figuring it out.
I've looked at STRQM, which is part of 57##-ST1, but I am more used to
column sizing and reformatting in WRKQRY. I do prefer using the SQL of
STRQM though.

Most of the GUI products have a long and complicated setup process you
have to run through.

The hardest part for most people using a query tool is knowing what to
query. For example, joining 5 files together, finding out there's no on
hand balance column and you have to calculate that, and cryptic column
names. All of which could be fixed by some decent views or join logical
files. I prefer a view over a join logical file because I'm getting more
used to the syntax and find it easier. Also, it allows for expansion by
being able to include various sql scalar functions and even my own user
defined functions. Many of the GUI tools setup is to have you redefine
your user data into metadata. Which basically is like creating the view
under the covers.


Rob Berendt