Progress
DataServer
for ORACLE Guide
ORACLE Views
ORACLE schema objects include views. A view is a presentation of data in one or more tables. The DataServer for ORACLE fully supports views that are subsets of a single table. Table 2–2 lists the level of support available for various types of views.
ORACLE views appear as tables in the Data Dictionary’s table list for the schema image, not as views. The Data Dictionary’s SQL View Report does not list ORACLE or other non-Progress views. Nor can you access them through the PRO/SQL menu functions.
In addition, Progress does not allow you to undo the deletion of a record with a view name inside a subtransaction block, so you must perform the deletion inside a transaction block. If you delete a view in a subtransaction block and then try to undo the deletion later, Progress returns a run-time error. See the Progress Programming Handbook for information on subtransactions.
Multi-table Views
The DataServer supports direct access to multi-table views. Use the following 4GL syntax to read rows from multi-table views:
You cannot use other Progress queries, such as the DEFINE QUERY, OPEN QUERY, GET, and DEFINE BROWSE statements, to access multi-table views.
Progress 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, Progress returns run-time errors if you try to update them with a Progress application.
Views Containing Aggregates
The DataServer supports access to columns in views that contain aggregates or functions only when the affected column has a name associated with it. Assign specific names to the columns when you define an ORACLE view. For example, the following SQL statement names a computed column in a view definition:
Use the following 4GL syntax to read rows from views that contain aggregates or functions:
You can also access the view by using the RUN STORED-PROC send-sql-statement option to send an SQL statement to select the data from the view. You can access a view by using the send-sql-statement option without adding index definitions for the view in the schema holder. See the "Sending SQL Statements" section for more information.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |