Retrieve SQL view definition from Progress 4gl database

If you are using the SQL-92 engine I would expect that standard SQL tools and techniques should work. The default interface that Progress provides is the "sqlexp" command line tool but you can use whatever you'd like (for instance, lots of people like SQuireL SQL client).

If you are referring to "embedded" SQL within the 4GL engine then you will need to use the data dictionary. Hopefully that isn't what you're talking about because there is nothing but pain and agony to be found by trying to use SQL from the 4GL side of things.

Progress views are held in sysprogress.sysviews. There is one row for each 2,000 characters of a view definition; a sequence row SEQ counts from 0 to N if you want to assemble a view by each 2,000 character piece.