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?

Solution 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.

Solution 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

Solution 3

select sysprocedures.procname from sysprocedures;

Comments

[Adriano Carneiro]

Did you just answer your own question using the information I provided in my answer??

[Peter Burns]

mouse over the time stamps; his answer was first

[CheeseConQueso]

@Adrian - I found the answer on google and posted before i saw yours, but jeff, i think Adrian posted a minute before me.

[Foxhound]

This is great, thankyou. Would you know how to execute said procedure?

[Foxhound]

To answer my above comment: call <procname>()

[Gabz]

God bless you, I've been looking for it all the day.