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	You must have one of: DBA authority You own the view and have SELECT permission on the underlying tables of the view
SAP Sybase IQ 16.0	You must have one of: ALTER ANY VIEW system privilege ALTER ANY OBJECT system privilege You own the view You must also have one of: SELECT ANY TABLE system privilege SELECT permission on the underlying tables of the view

Database Version

View Privileges

SAP Sybase IQ 15.3 and 15.4

You must have one of:

DBA authority
You own the view and have SELECT permission on the underlying tables of the view

SAP Sybase IQ 16.0

You must have one of:

ALTER ANY VIEW system privilege
ALTER ANY OBJECT system privilege
You own the view

You must also have 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, expand IQ Servers > Schema Objects > Views, and then select 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.