Query to list procedures

[Alfetta159]

What would a query to list the procedures in a Progress DB look like?

 

[Rob Fitzpatrick]

This should get you started:
Progress KB - How to export SQL stored procedure definitions from a database

 

[TomBascom]

Rob is correct but don't be surprised if you don't find any.

Most OpenEdge databases do not have much, if anything, in the way of stored procedures or sql views.

Most usage of SQL with OpenEdge is for reporting. The OLTP side of the database is almost certainly a Progress 4GL application and the 4GL is completely unaware of SQL-92 stored procedures.

The equivalent, from the 4gl perspective, is to make Progress Appserver calls. These can also be exposed to non-4gl clients if the creator of the application was so inclined.

It is also very common that a lot of what people use stored procedures for in other applications is directly embedded in the "business logic" of a 4gl application.

Having said all of that... *why* do you want a list of procedures? Knowing that might help us to guide you more comprehensively.