SQL Views

A new concept called SQL views was introduced in Clarify 11.5, which allows an administrator to define the actual SQL for a view, as opposed to the schema tool dynamically building the SQL.

SQL views allow for:

• A view with only one table. A common use of this is to take advantage of aggregates (max, min, count, sum, avg, etc.).
• A view using multiple, unrelated tables.
• A view that uses the UNION keyword to consolidate between multiple tables or views.

For example, the baseline view wipelm_all (view #: 5748) is a SQL view in order to take advantage of the UNION syntax.

Dovetail SchemaEditor supports these SQL views, both in Schema Script and in Data Dictionary files.

Note that a SQL view's definition in XML (Data Dictionary or Schema Script) resembles a table more than a view.

Did this topic help you? Email us your feedback.
Last updated: 4/13/2009 2:41:30 PM
© by Dovetail Software, Inc.