Syntax

The DataServer supports direct access to multi-table views. Use the following ABL syntax to read rows from multi-table views:

FOR EACH view-name { NO-LOCK | SHARE-LOCK } :

You cannot use other ABL queries, such as the DEFINE QUERY, OPEN QUERY, GET, and DEFINE BROWSE statements, to access multi-table views.

ABL cannot recognize whether a view in an Oracle database is a multi-table view. Although the DataServer copies multi-table views into the schema image, ABL returns run-time errors if you try to update them with an OpenEdge application.