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

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 09/14/2017
09:17:24 AM:

I tried using WRKOBJ but that just returns all programs.

I guess I need to use a SQL command but what would I select?

I use the following from iNavigator -- but it should work from the
ACS Run SQL Scripts option, too. Note that I qualify the list using the
name of our production library so that I don't get everything on the
system.

Select count(*) from SYSROUTINE
where specific_schema = 'PGM460'
group by specific_schema;

Select cast(specific_schema as char(10))
, cast(specific_name as char(10))
, routine_name
, routine_text
, routine_type
, routine_body
, external_name
, external_language
, max_dynamic_result_sets
, in_parms
, out_parms
, inout_parms
, long_comment
from SYSROUTINE
where specific_schema = 'PGM460'
order by specific_name;

Sincerely,

Dave Clark