Refresh immediate on MQTs for Db2 for i is not yet realized.
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: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of Gad Miron
Sent: Montag, 23. April 2018 06:19
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: MQT Refresh Immediate
Hello pundits
Need help with the following:
Some years ago (was it ten?) I've created an MQT to "union" customers from
several disparate applications on the i so a web application may select one
regardless of it's original application.
it goes as follows:
CREATE OR REPLACE TABLE URPS/CUSTS_V1MQ AS select 'a' as type, custn as
custno, name from custs_app1 union select 'b' as type, customer as custno,
name from custs_app2 union select 'c' as type, cust as custno, name from
custs_app3 etc..
DATA INITIALLY IMMEDIATE
REFRESH DEFERRED
MAINTAINED BY USER
I tried REFRESH IMMEDIATE then but found it's not supported on the i (it
was iseries or AS/400 then) so I had the web app issue a REFRESH TABLE
first.
(My intention was building a LF over the MQT keyed by type and custno)
I've asked (at the time) a helpful IBM guy if REFRESH IMMEDIATE will be
supported in the future (RFE?) and was discouraged.
Does any of you know if REFRESH IMMEDIATE is now supported?
is there an open RFE ?
TIA
Gad
Oh, and what MAINTAINED BY SYSTEM means?
--
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:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
https://archive.midrange.com/midrange-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
