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

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Rob

I'm curious about your comment on column sizing and reformatting - I 
find it is all there in STRQM, too - and that there are even better 
formatting options there - the one I like most is wrapping within a column.

I assume you know about using F13 to switch between the SQL statement 
(in SQL mode) and form definition - the latter gives you all the 
reformatting you could want, I think.

I think QM is one of the best-kept secrets on the i - and it goes beyond 
reporting to doing almost anything you want with SQL. Query for i and 
Web Query are both limited to reporting only, so far as I have heard.

Vern

On 1/17/2012 7:30 AM, rob@xxxxxxxxx wrote:
> 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