Read access is required to the following system views in order for this additional functionality to work correctly:
In particular, for stored procedures, the following query is run:
SELECT T1.procid,, T2.seqno
FROM informix.sysprocedures AS T1, informix.sysprocbody AS T2
WHERE procname = ?
AND T2.procid = T1.procid
AND datakey = 'T'
ORDER BY T1.procid, T2.seqno
My guess is you don't have access to informix.sysprocedures†or informix.sysprocbody.

On Tue, Jul 5, 2011 at 6:58 PM, Chris Yeo (cyeo) <> wrote:


Iíve installed Squirrel SQL Client 3.2.1 with Informix plugin. When I connect to the Informix DB, †I can see the tables but I canít see the stored procedures. Appreciate any suggestion.


All of the data generated in your IT infrastructure is seriously valuable.
Why? It contains a definitive record of application performance, security
threats, fraudulent activity, and more. Splunk takes this data and makes
sense of it. IT sense. And common sense.
Squirrel-sql-users mailing list