× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Have you posted it as an "Idea" aka RFE here?

https://ibm-power-systems.ideas.ibm.com/


On Sun, Jul 10, 2022 at 4:17 PM Robert Rogerson <rogersonra@xxxxxxxxx>
wrote:

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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.