Dump and Load - SQL92 - Forum - OpenEdge General - Progress Community

Dump and Load - SQL92

  • I was wondering if there was a way to dump SQL-92 view definitions? I know in the data dictionary I can dump SQL-89 views but I can't find any documentation that describes how I would dump the SQL-92 view definitions. Currently using Openedge 10.2A.

  • I suspect (but could be wrong) that the SQLSCHEMA command line tool should be able to do this for you..

  • That is the one thing I run into as well.

    There is a grant and a synonym dumped for a SQL92 view, but the actual view is never dumped through sqlschema. None of the options give an indication that they are dumping the views as well.

    Is there another utility? Or do I need to dump SYSVIEWS directly...?