Dump of SQL View - Forum - OpenEdge RDBMS - Progress Community
 Forum

Dump of SQL View

This question is answered

Hi All,

OE11.* 

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 

Regards,

Mark Davies

Verified Answer
  • The SQL should be included in the output from dumping all schema.  There is a utility. 

    https://knowledgebase.progress.com/articles/Article/P111448

    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)

All Replies
  • The SQL should be included in the output from dumping all schema.  There is a utility. 

    https://knowledgebase.progress.com/articles/Article/P111448

    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)

  • Hi Mark,

    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" (

           "RepName",

           "Region",

           "SalesRep",

           "MonthQuota"

    ) as

    SELECT * FROM PUB . SALESREP WHERE SALESREP = 'BBB'

    ;

    It's also possible to get the definitions by querying SYSPROGRESS.SYSVIEWS.

    HTH,

    Rob

  • You can use SQLSCHEMA utility. More information here

  • Thanks - will give this a try

    Regards,

    Mark Davies