Re: How do I know if a TRACE is active in a SP?

If they are using the same file with out the append option then AFAIR the file will be overwritten each time. There is/appears an inconsistency in the versions I have here whether an active TRACE is passed to the call SPL. My 9.40 appear to pass the TRACE, some of the 9.20s don't David Reed wrote: > Hi > How do I know if a TRACE in a Stored Procedure is already active? Can I > interrogate a system table for that information? I have some SP's that > goes about 10 levels deep and would like to know in the bottom ones if > the top SP's have already activated a trace, else if the bottom one > activates it again, it overwrite the existing one. > Regards > David > > sending to informix-list > -- Paul Watson # IIUG # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.iiug.org # sending to informix-list