List of stored procedures

[dhuesman]

Does anyone know how to obtain a list of stored procedures within a schema so that one could know the signature to complete the DROP PROCEDURE command? I have a case of an overloaded procedure which I'm trying to drop all instances of and cannot find any documenation on how to get a simple list so I could qualify the DROP command properly.

Thanks.

[arrow483]

Re: List of stored procedures

In iSeries Navigator, open Database / Schemas / Procedures

[dhuesman]

Re: List of stored procedures

Unfortunately I don't have access to do that. I was trying to use an SQL command to obtain the list natively.

[Andrew K]

Re: List of stored procedures

Logical file QSYS2/SYSPROCS contains all definitions for Stored Procedures.

Andrew

[pjk]

Re: List of stored procedures

select SPECIFIC_SCHEMA, SPECIFIC_NAME from qsys2/sysprocs where NOT (SPECIFIC_SCHEMA in ('QSYS','SYSIBM','SQLJ','EJSADMIN','QIWS'))
order by SPECIFIC_SCHEMA, SPECIFIC_NAME

This is an SQL I had made before to get the names of stored procedures I had created. This query filters out system ones--if you want ALL stored procedures, just take out the where clause.

[dhuesman]

Re: List of stored procedures

Worked Great...

Thanks!