Re: current_date in MQT

[Gad Miron <gadmiron@xxxxxxxxx>]

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)