Re: Capturing SQL

David Williams wrote: > > In article <6js2k9$6jr@newsserv.cs.sunysb.edu>, Joe Trubisz > <trubisz@cs.sunysb.edu> writes > >Hi... > > > >We have a program which calls many subroutines from a > >library, all of which make SQL calls. We do not have the > >source for the library. > > > >I'm aware of onstat -g sql, but that give only a snapshot > >of the current SQL being executed. Is there a better way > >(or a tool) which exists which would allow me to capture > >ALL the SQL these calls are making? > > > > SET EXPLAIN ON> > in 4GL?? > > >Thanks in advance, > >Joe > > -- > David Williams > > Maintainer of the Informix FAQ > Primary site (Beta Version) http://www.smooth1.demon.co.uk > Official site http://www.iiug.org/techinfo/faq/faq_top.html > > I see you standin', Standin' on your own, It's such a lonely place for you, For > you to be If you need a shoulder, Or if you need a friend, I'll be here > standing, Until the bitter end... > So don't chastise me Or think I, I mean you harm... > All I ever wanted Was for you To know that I care I don't think SET EXPLAIN ON captures *all* the SQL, only those bits that use queries (and therefore the optimizer). It doesn't get plain INSERT statements, for example. I base this on SE. Onliners may know different. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/