Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > SQL Statements > ALTER VIEW

ALTER VIEW

The ALTER VIEW statement regenerates a view using an existing view definition at the current server.

The XDB Server operating environment only provides syntax support for this statement at this time.

Invocation

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared only if DYNAMICRULES run behavior is implicitly or explicitly specified.

Authorization

The privilege set that is defined below must include at least one of the following:

Ownership of the view
SYSADM authority
SYSCTRL authority

If the statement is embedded in an application program, the privilege set is the privileges that are held by the authorization ID of the owner of the plan or package. If the statement is dynamically prepared, the privilege set is the union of the privilege sets that are held by each authorization ID of the process.

Syntax

Bold text indicates clauses or options that are supported only syntactically.

ALTER VIEW view-name REGENERATE

Description

view-name: Identifies the view to be regenerated. The name must identify a view that exists at the current server.
REGENERATE: Specifies that the view is to be regenerated. The view definition in the catalog is used, and existing authorizations and dependent views are retained. The catalog is updated with the regenerated view definition. If the view cannot be successfully regenerated, an error is returned.