View Queries

Query	The Returned Rows Indicate	Resolution
VIEWS-1	Views are defined in the Data Designer and not found in the database.	If you want to delete the view definition, use Application Designer (select File, Delete). Otherwise, to create the SQL view, use Application Designer. On Db2 z/OS, if there are dependent view failures after creating materialized views, add those views into a project and recreate views.
VIEWS-2	Views are defined in the database and not found in the Data Designer.	Drop the view if it is not valid. Otherwise, define a new view in the Application Designer.

Query

The Returned Rows Indicate

Resolution

VIEWS-1

Views are defined in the Data Designer and not found in the database.

If you want to delete the view definition, use Application Designer (select File, Delete).

Otherwise, to create the SQL view, use Application Designer.

On Db2 z/OS, if there are dependent view failures after creating materialized views, add those views into a project and recreate views.

VIEWS-2

Views are defined in the database and not found in the Data Designer.

Drop the view if it is not valid.

Otherwise, define a new view in the Application Designer.