Recompiling and Enabling a View

Recompile and enable a disabled view to make it available for use by the database server. Enabling a view changes the definition of the view but does not change data inside the view.

Prerequisites

Database Version	View Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. All of these: SELECT permission on the underlying tables of the view. You own the view.
SAP Sybase IQ 16.0	Requires one of: ALTER ANY VIEW system privilege. ALTER ANY OBJECT system privilege. You own the view. Also require one of: SELECT ANY TABLE system privilege. SELECT permission on the underlying tables of the view.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.
The view is disabled.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Views > Views.
Select one or more views from the right pane and either:
- Click the arrow to the right of the name and select Recompile and Enable, or
- From the Administration Console menu bar, select Resource > Recompile and Enable.
Note: Use Shift-click or Control-click to select multiple views.
Click Yes.