Is there a way to dump SQL views created in an OpenEdge database?
I am looking for a way to create the SQL View again, but am missing the original SQL Query I did to create it in the first place.
Thanks in advance
The SQL should be included in the output from dumping all schema. There is a utility.
Unfortunately we've had problems re-running the output from that utility and recreating an exact copy of the original definitions. I don't think it was designed with that purpose in mind. That would only affect you if you were trying to recreate *all* the SQL schema in the entire database. (all views, permissions, etc)
Try the SQLSCHEMA utility from PROENV. For example,
sqlschema -u <username> -a <password> -t <schema>.<view> progress:T:<hostname>:<port>:<databaseName>
It will list the original View definition, so something like:
create view "MYSCHEMA"."SALESREP" (
SELECT * FROM PUB . SALESREP WHERE SALESREP = 'BBB'
It's also possible to get the definitions by querying SYSPROGRESS.SYSVIEWS.
You can use SQLSCHEMA utility. More information here
Thanks - will give this a try