Re: MQT over SP?

change it from a SP to a UDTF...

I think that will allow you to create a MQT..

Why you'd bother is another question. You do realized the Db2 for IBM i
doesn't support system maintained MQTs and that you'll have to manually run
the refresh? And that the MQT must not be in use when you want to refresh
it.

An alternative to running an MQT refresh would be a set of triggers over
the base table(s) that update the MQT table. But with a UDTF involved that
would be complex.

Thus, I've never bothered to use MQTs. Instead, I've used EVI indexes with
aggregate values instead, those are system maintained.

Charles





On Wed, Sep 30, 2020 at 10:10 AM Justin Taylor <jtaylor.0ab@xxxxxxxxx>
wrote:

I have a Db2 stored procedure (SP) that returns a result set. I really
need to make a materialized query table (MQT) over that SP. When I try, I
get a SQLSTATE 42601.

Anyone know of a way to accomplish this? Simply copying the code from the
SP isn't an option.

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