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
http://www.starbase-iseries.org/ ... there are some links there to
additional information (a demo & redbooks) ... check meeting topics .
..
http://www.starbase-iseries.org/LUG/STARBASE/topics.htm
the web site is not up-to-date ... the meeting topic next week is on
Security
Pete, I just downloaded "Getting started with DB2 Web Query for System
i"
redbook from :
http://www.redbooks.ibm.com/redpieces/abstracts/sg247214.html?Open
Haven't read it all and don't have the product yet, but from what I've
read
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/400
query definition into the Web Query product. In essence, Web Query
would
run RUNQRY command on the back end and integrate the result set within
the
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.
Nothing
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
cross
system joins... something that can't be done natively in SQL, without
additional products of course.
Elvis
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The
Ugly
October 16
2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i,
eServer
iSeries and the server affectionately known as the AS/400
-----Original Message-----
Subject: Re: Making Matched Records with Primary File in Query an Outer
joininSQL
<snip>
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 .
</snip>
Pete
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/midrange-l.
midrange.com
