You can ask your user group to get a demo of the Web Query from IBM.
The Evansville user group http://www.starbase-iseries.org/
just had such
a demo from Jamie Barnes from IBM
... there are some links there to
additional information (a demo & redbooks) ... check meeting topics .
the web site is not up-to-date ... the meeting topic next week is on
Pete, I just downloaded "Getting started with DB2 Web Query for System
redbook from :
Haven't read it all and don't have the product yet, but from what I've
so far the answer looks to be no, there is no enhanced query/400 to SQL
converter. Instead you have an option to integrate the existing
query definition into the Web Query product. In essence, Web Query
run RUNQRY command on the back end and integrate the result set within
Web Query tool.
If my interpretation is correct, that would mean that you wouldn't
necessarily have to convert all your queries to true Web Query objects.
That would also mean that you'd still be using CQE on the back end.
wrong with that as long as performance is acceptable.
Overall, product looks intriguing. I'm going to ask our hardware guy to
order it to learn more when I get a chance. What got my attention is
system joins... something that can't be done natively in SQL, without
additional products of course.
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i,
iSeries and the server affectionately known as the AS/400
Subject: Re: Making Matched Records with Primary File in Query an Outer
I wonder how the new Web Query product is going to migrate existing
Query/400 queries (if it indeed does do that)? They must have a better
tool than RTVQMQRY .
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives