sa_recompile_views system procedure

ignore_errors
Use this optional INTEGER parameter to specify whether to return errors during the recompilation. If you specify 0, an error
is returned for each view for which column definition failed. If you specify 1, or any value other than 0, no errors are returned.
The default is 0.

This procedure is used to locate views in the catalog that do not have column definitions and execute an ALTER VIEW statement
with the RECOMPILE clause to create the column definitions. The procedure does this for each view that does not have a column
definition until there are none left that require compilation or until any remaining column definitions cannot be created.
If the procedure is unable to recompile any views, an error is reported. Errors can be suppressed by specifying a non-zero
parameter to this procedure.

Caution

The sa_recompile_views system procedure should only be called from within a reload.sql script. This procedure is used by the Unload utility (dbunload) and should not be used explicitly.

The sa_recompile_views system procedure does not attempt to recompile materialized views or any view marked DISABLED.

The following example from a reload.sql script uses the sa_recompile_views system procedure to locate view definitions stored in the catalog that do not have column
definitions and cause the column definitions to be created. Errors are ignored.