|
From: Robert M. <rob...@gm...> - 2011-07-06 14:01:33
|
Read access is required to the following system views in order for this additional functionality to work correctly: - informix.sysfragments - informix.sysindices - sysmaster:informix.sysptnhdr - informix.sysprocbody - informix.sysprocedures - informix.systables - informix.systriggers - informix.systrigbody - informix.sysviews 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) <cy...@ci...> 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > |
