Re: How can I get a list of stored procedures on the system?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Darryl

No one else has exactly said this, so I will venture out - stored 
procedures are not usually objects that have the same name as the 
procedure - they are SQL entries in a table that do have a program 
behind the scenes.

So they are defined in an SQL-ish fashion - you've seen several posts 
saying to look at the SYSPROCS table, which is where the definitions of 
SPs are stored - SQL resolves these definitions into program calls when 
executed.

HTH
Vern

On 9/14/2017 8:17 AM, a4g atl wrote:
> I tried using WRKOBJ but that just returns all programs.
>
> I guess I need to use a SQL command but what would I select?
>
> TIA
>
> Darryl Freinkel