RE: current_date in MQT

... seems to be difficult! IIRC they told me when the MQT was introduced the
automatic maintenance will come.
As a "workaround" we get the includes in EVIs.
But I have no idea whether or when they will have finished the MQT automatic
maintenance

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"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)
"Learning is experience ? everything else is only information!" (Albert
Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gad
Miron
Sent: Tuesday, 5 March 2024 20:12
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Re: current_date in MQT

Hello Birgitta

This thread reminds me of an MQT question I asked waaaay back .
I created an MQT with
DATA INITIALLY IMMEDIATE
REFRESH DEFERRED
MAINTAINED BY USER

I asked then (10 years ago ?) whether a MAINTAINED BY SYSTEM will be
available sometime in the future.

Have the future arrived yet?

TIA
Gad

from: "Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>
subject: RE: 428EC on current_date in MQT

There are restrictions!
Here an excerpt from the SQL Reference (CREATE TABLE Statement):

When a materialized query table is defined with ENABLE QUERY
OPTIMIZATION, the following additional select-statement restrictions

apply:

? Must not include any special registers.
? Must not include any non-deterministic functions.
? The ORDER BY clause is allowed, but is only used by REFRESH. It may
improve locality of reference of data in the materialized query table.
? If the subselect references a view, the select-statement in the view
definition must satisfy the preceding restrictions.

Mit freundlichen Gr??en / Best regards

Birgitta Hauser
Modernization ? Education ? Consulting on IBM i Database and Software
Architect IBM Champion since 2020

"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) "Learning is experience ?
everything else is only information!" (Albert
Einstein)

--
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.