Kbase P24925: How to create an SQL92 VIEW from a Progress 9.x database table?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/15/2008 |
|
Status: Verified
GOAL:
How to create an SQL92 VIEW from a Progress 9.x database table?
FACT(s) (Environment):
Progress 9.x
FIX:
The following two code examples demonstrate the SQL92 syntax that can be used to create SQL92 VIEWs of the Customer and Order tables of the Progress Sports2000 demo database:
DROP VIEW myCustomer;
CREATE VIEW myCustomer
AS SELECT CustNum, Name, City, State, Country, PostalCode FROM PUB.Customer
WHERE state IN ( 'NH', 'MA', 'ME', 'RI', 'CT', 'VT' ) WITH CHECK OPTION;
DROP VIEW myOrder;
CREATE VIEW myOrder (myOrdernum, myCustNum, myOrderDate, myShipDate, mySalesRep)
AS SELECT Ordernum, CustNum, OrderDate, ShipDate, SalesRep FROM PUB.Order
GROUP BY Ordernum, CustNum, OrderDate, ShipDate, SalesRep;