Feedback
Did this article resolve your question/issue?

   

Article

How to create a SQL view in an OpenEdge database

« Go Back

Information

 
TitleHow to create a SQL view in an OpenEdge database
URL NameHow-to-create-a-SQL-view-in-an-OpenEdge-database
Article Number000163508
EnvironmentProduct: Progress
Version: 9.1x
Product: OpenEdge
Version: All Supported Versions
OS: All Supported Platforms
Other: SQL
Question/Problem Description
How to create a SQL view in an OpenEdge database
How to create a SQL view over OpenEdge tables
What tools can be used to create OpenEdge SQL views?
Steps to Reproduce
Clarifying Information
The view owner needs to be granted the RESOURCE permission;
 
GRANT resource to owner_name;
COMMIT;
Error Message
Defect Number
Enhancement Number
Cause
Resolution
Views can be created over OpenEdge database tables using the OpenEdge SQL CREATE VIEW statement. The syntax of the CREATE VIEW statement is as follows:
CREATE VIEW [ owner_name.]view_name
[ ( column_name, column_name,... ) ]
AS [ ( ] query_expression [ ) ]
[ WITH CHECK OPTION ] ;
 
The CREATE VIEW statement must be followed by the COMMIT statement  for the new view to be permanently committed to the database.

For example:
CREATE VIEW ne_customers AS
SELECT Name, Address, City, State
FROM pub.Customer
WHERE State IN ( 'NH', 'MA', 'ME', 'RI', 'CT', 'VT' );

COMMIT;
 
Statements may be entered through any of the following tools:
  • The command-line SQL Explorer tool provided since Progress 9.1
  • The GUI SQL Explorer tool provided with Progress 9.1
  • The SQL Editor in the DB Navigator perspective of OpenEdge Architect (OE 10) or Progress Developer Studio for OpenEdge (OE 11 and 12)
  • Any third-party SQL query tool that can connect to an OpenEdge database using ODBC or JDBC.
Workaround
Notes
Last Modified Date11/3/2021 6:37 PM
Attachment 
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.