Limitations of logical views

The SQL constructs you can use to define a Logical View are limited:

•You cannot use ORDER BY, CONNECT BY or START WITH clauses.

•You cannot use the UNION, INTERSECT and MINUS set operators. Only UNION ALL is allowed.

A Logical View's SQL Statement may contain joins, subqueries, WHERE, HAVING and GROUP BY clauses, and SQL functions.

A Logical View:

•Cannot be used as the Parent Object or Child Object of a Relationship.

•Cannot be a supertype or subtype.

•Cannot be the Transition Table of a Constraint.

By default, Logical Views cannot freely manipulate data in the same way as Tables. See the help topic on data manipulation through logical views for details.

However, you can customise data manipulation through Logical Views by using rule-based logical views.

Update Notify is the standard USoft behavior in C/S applications that data on the screen is refreshed if that data is updated by the Rules Engine. Update Notify is NOT supported on multi-table Logical Views; the user or the application must re-query to get the new data in view.

The fact that Update Notify is not supported on multi-table Logical Views can lead to unexpected results on the screen if the same underlying column is used multiple times in the Logical View's SELECT list.