Skip to content

Recompile and Enable Invalid Views in Sybase IQ

February 22, 2013

 

In this post I show how to recompile and enable invalid views in IQ 15.x using Sybase Central.

 

  1. Open Sybase Central and connect to the database with a user with DBA authority or as the user that owns the views.
  2. On the right panel right click on views

  1. Click on the columns Status to order the views by status.
  2. Select all the views with invalid status.
  3. Right on any of the selected views and select the option “Recompile and Enable”.

 

The views will be recompiled and enabled one by one. If there are views that depend on other views that are in invalid status, Sybase Central will display a “The enable setting for the view ‘<depending view>’ could not be written to the database. Cannot use view ‘<depending view>’ because is invalid.

  1. Click OK to compile and enable the next view. Repeat this step for every depending view.
  2. Repeat steps 2 to 5, this will allow you to compile and enable the views that depend on other views that were compiled on the previous pass. The number of passes required depends on the level of views dependencies.

If there are invalid views after this process, investigate the cause, and correct the view definition, disable or delete the view.

Advertisements

From → SAP IQ

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: