Table Altered in a compare but related Views not generated.

Document ID : KB000054072
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

A compare Strategy will regenerate the Table correctly, but the required View (SELECT VIEW ..) Statement will not be regenerated within the compare Strategy. Why?

Solution:

Select UPDATE OPTION=YES under the RC/M Compare Strategy Analysis Panel (Strategy Batch/Online submit Panel ) and set the control option: REGENERATE VIEWS to YES.
For details, please see RC/Migrator User Guide R11.5, under Section ANALYSIS, VALID PARMFILE

Control Parameter for regular Analysis: REGVIEW
This specifies the regeneration of VIEW statements for views that are affected by an ALTER TABLE statement for a regular Analysis.

Control Parameter for Recovery Analysis: RREGVIEW
This specifies the regeneration of VIEW statements for views that are affected by an ALTER TABLE statement for a Recovery Analysis.