Dave,
AFAIK IBM has not forgotten it, but it has only minor priority.
I just asked Scott Forstie about that on one of the latest conferences.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxx> On Behalf Of Gad Miron
Sent: Samstag, 25. August 2018 12:08
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: SQL Views - worth it ?
Dave
Some years ago following a similar issue I've opened a *D*esign *C*hange *R*
equest (MRT MR033115573)
asking for a MQT's feature " REFRESH IMMEDIAT MAINTAINED BY SYSTEM" to be
available.
I've even had some responses from IBM but got no further. see following.
If others seconds this DCR it may help...
*Design Change Request *- Thank You for your Design Change Request
submission regarding System i.
You request has been acknowledged and issued the following
Marketing Requirement Tracking number : MR033115573
*Title* : MQT's REFRESH IMMEDIAT MAINTAINED BY SYSTEM
*Description *: the following MQT creation is available for some years now.
I'd like to know if REFRESH IMMEDIAT MAINTAINED BY SYSTEM will be available
anytime soon
CREATE TABLE DailyMQT AS
(SELECT Branch, salesdate,
SUM(Revenue) as Total_Revenue,
SUM(Units) as Total_Units,
FROM SalesDetails
GROUP BY Branch, salesdate)
DATA INITIALLY IMMEDIATE
REFRESH DEFERRED
MAINTAINED BY USER;
Alternately, enabling a LF over a LF might do the trick as well.
Gad
I agree 100%. I am not impressed with DB2 SQL Views. Even
adding indexes doesn't improve their performance enough since, as you
pointed out, they are materialized at execution time. So, there is no
way they can perform as well as DDS Logical files. But I have heard
some strong adherents claim that SQL Views perform just as well as DDS
Logical file.
Well, I disagree -- been their, got that T-shirt. Had to go with an
MQT to get the performance of a DDS Logical file except that MQT's are
not updatable.
Sincerely,
Dave Clark
--
int.ext: 91078
direct: (937) 531-6378
home: (937) 751-3300
Winsupply Group Services
3110 Kettering Boulevard
Dayton, Ohio 45439 USA
(937) 294-5331
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
