Re: Server Studio - capture activity across all tables for a minute or two? Then report on it?

William Fields wrote: > I have an application I'm trying to figure out what the results are at the > database level when certain functions are executed. > > Is there a way, perhaps using Server Studio, that I could turn on a capture, > execute the function, then turn the capture off, and see exactly what > changed at the table level? > > If not Server Studio, any other ideas to arrive at the same solution? > Not in Server Studio but - a DBA could do onmode -Y (?) for a session and get the sql that is executed. - a DBA could install Informix SPY to capture info. - which programming language is the client written in? there and ODBC and JDBC tracing abilitys and esql/c or 4gl has SQLIDEBUG. > Thanks. > > -- > William Fields > Code Contortionist > MCSD - Microsoft Visual FoxPro > US Bankruptcy Court > Phoenix, AZ > > ".dll hell - .rpm hell - whatever. > The grass is always greener"

David I seem to recall Server Studio has a facility whereby a function (i.e. stored procedure) can be traced such that the code is displayed as it is executed (a la Interactive Debugger) ? I profess it's been awhile since I played with ServerStudio. It also depends on whether the original author's 'certain functions' actually meant Informix stored functions/procedures. William ? Regards Glyn ----- Original Message ----- From: <david@smooth1.co.uk> Newsgroups: comp.databases.informix To: <informix-list@iiug.org> Sent: Saturday, June 24, 2006 3:47 PM Subject: Re: Server Studio - capture activity across all tables for a minuteor two? Then report on it? > > William Fields wrote: > > I have an application I'm trying to figure out what the results are at the > > database level when certain functions are executed. > > > > Is there a way, perhaps using Server Studio, that I could turn on a capture, > > execute the function, then turn the capture off, and see exactly what > > changed at the table level? > > > > If not Server Studio, any other ideas to arrive at the same solution? > > > > Not in Server Studio but > > - a DBA could do onmode -Y (?) for a session and get the sql that is > executed. > - a DBA could install Informix SPY to capture info. > - which programming language is the client written in? > there and ODBC and JDBC tracing abilitys and esql/c or 4gl has > SQLIDEBUG. > > > Thanks. > > > > -- > > William Fields > > Code Contortionist > > MCSD - Microsoft Visual FoxPro > > US Bankruptcy Court > > Phoenix, AZ > > > > ".dll hell - .rpm hell - whatever. > > The grass is always greener" > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >