Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Unable to access SQL-92 view after creating it using SQL explorer

SQL-92 views created do not appear within a third party products like Microsoft Access?

SQL-92 views created using the SQL Explorer Tool are not being saved in the database.

CAUSE:

Transaction was not committed

FIX:

Use COMMIT statement after creating the view to commit the view to the database, otherwise it's only active for the session.

For example, to store the view permanently you should do something like this:

CREATE VIEW order_count (cust_number, norders) AS
SELECT cust_no, COUNT(*)
FROM orders
GROUP BY cust_no;
COMMIT;

To make sure that the transaction is committed, check the sysviews table using the following command:

select * from sysprogress.sysviews where viewname = 'viewname';