<div>
P.S. Below does work ... wonder why I should &quot;AVOID USING&quot;?<br />
<br />
REFRESH TABLE MYLIB.MYTABLE;<br />
<br />
Volking
</div>


P.S. Below does work ... wonder why I should "AVOID USING"?

REFRESH TABLE MYLIB.MYTABLE;

Volking

<div>
<div class="content wysiwyg-content">
Per DOCs .... <br />
I quote<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;You should avoid using the REFRESH TABLE statement to update user-maintained materialize query tables.&quot;<br />
and again<br />
&nbsp; &nbsp; &nbsp; &nbsp; &quot;Use insert, update, delete, or load operations might be more efficient than using the REFRESH TABLE statement.&quot;<br />
<br />
Can I please get sample refresh syntax ..... if my MQT table was named MYLIB.MYTABLE<br />
<br />
<br />
<br />

</div>
</div>


Per DOCs .... 
I quote
        "You should avoid using the REFRESH TABLE statement to update user-maintained materialize query tables."
and again
        "Use insert, update, delete, or load operations might be more efficient than using the REFRESH TABLE statement."

Can I please get sample refresh syntax ..... if my MQT table was named MYLIB.MYTABLE





How? REFRESH TABLE of MQT in V5R3?

IBM i, formerly known as AS/400, is a proprietary, midrange, object-based operating and application system. It includes a relational database, a menu-driven interface, support for multiple users, block-oriented terminal support and printers, and supports security, communications, and web-based application servers including Websphere, Apache and Tomcat.