Re: MQT REFRESH IMMEDIAT MAINTAINED BY SYSTEM

Thanks Gad

Rob

On Sat, Jul 9, 2022 at 1:26 PM Gad Miron <gadmiron@xxxxxxxxx> wrote:

Wow, this reminds me of a query I have posted here some (many) years

ago

I have even opened a DCR (*MR033115573) * - see partial log following

Gad


Hello pundits

Need help with the following:

April 23 2018
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




Gad Miron <gadmiron@xxxxxxxxx>
Sat, Aug 25, 2018, 1:07 PM
to rpg400-l
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



date: Mon, 23 Apr 2018 07:18:58 +0300
from: Gad Miron <gadmiron@xxxxxxxxx>
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?


------------------------------


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)

date: Thu, 7 Jul 2022 14:51:10 -0400
from: Robert Rogerson <rogersonra@xxxxxxxxx>
subject: MQT on IBM i and maintained by system

Hello All,

My boss found this article (
https://developer.ibm.com/articles/dm-0509melnyk/) on MQTs which

refers

to

MQTs maintained by system. I believe this article is referring to DB2

LUW

although I couldn't find the database specifically referred to.

I then found this article on stackoverflow (

https://stackoverflow.com/questions/55287128/db2-for-i-triggers-once-per-statement-but-comparing-before-and-after-values

)
where Charles mentions that maintained by system is not available on

the

IBM i.

As the comment was from March 2019 I just wanted to confirm that MQTs
maintained by the system are still not available on the IBM i. I

couldn't

find any documentation to say they were now available but I may have

missed

it.

MQTs maintained by the system are still not available on the IBM i

correct?

Thanks,

Rob

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com