How do I list all stored procedures in Informix?

Question

I'm looking for a way to list all the stored procedures in my database running on Informix.

Is there a table in the "informix".* database that lists stored procedures along with detail information about them?

Answer 1

Yes, there is. It's called sysprocedures. Try this to see all there's to see:

select * from sysprocedures

For more information on what detailed information is available, read about sysprocedures and sysprocbody and sysproccolumns.

Answer 2

Get the procid of the stored procedure from the below query

select sysprocedures.procname,sysprocedures.procid from sysprocedures

and provide the procid in the below query to view the whole stored procedure

select data from sysprocbody where procid = @procid and datakey = 'T' order by seqno