Yeah, and you can't use *LIBL on your queries, moving them from
system-to-system is also a PITA.
QU2 is not an i5/OS application, it's a ported Unix application that has
some very obvious deficits.
It just shows that IBM does no longer commit to i5/OS and the System i
platform. I mean, QU2 is obviously broken in many ways, which could've
been ruled out with even the most simple QA.
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Crosby
Sent: Monday, October 22, 2007 10:14 PM
To: 'Midrange Systems Technical Discussion'
Subject: Q/400 to Web Query
Here's some interesting items.
(1) The marketing of Web Query ("WQ") says you can import existing Q/400
queries to Web Query. That's technically true, but it's not 'the truth,
whole truth, and nothing but the truth" so to speak.
WQ, during design, accesses files via metadata, not by actually looking
the database. Before you can query a file, you must create the metadata
that file. WQ then uses the metadata when designing the
report/graph/whatever. Fair enough.
When you import a Q/400 query (and I do mean 'import', not 'convert')
have available only what fields were actually used in the Q/400 query,
all fields in the file. You cannot add any additional fields from any
the files named in the original Q/400 query. WQ sees only the imported
metadata of the Q/400 query. Essentially, the imported query becomes a
(2) Another difference in WQ vs Q/400: Once a query has been designed,
can't change the file used. In Q/400 if you had 2 (or more) files with
same record format, you could change the file name and it would still
fine. Not with WQ. There is no way to do that. If you're careful
how you load metadata, you _can_ get WQ to use the library list at
Or you go direct to the metadata and start changing. I have a DCR open
IBM to allow the file to be named at runtime.