Re: Capturing SQL

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