Re: current_date in MQT

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)