Re: MQT Refresh Immediate

Thanks Birgitta .

Do you know of a RFE regarding the MQT Refresh Immediate
or better, Is IBM going to add this DB feature anytime soon ?

Gad


date: Mon, 23 Apr 2018 06:46:22 +0200

from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: RE: MQT Refresh Immediate

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