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.data, 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.
Rob

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

Hi,

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.

Thx.


------------------------------------------------------------------------------
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.
http://p.sf.net/sfu/splunk-d2d-c2
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users