Re: TRACE CURRENT in SPL

Posted in 1997

Greg — Sat, 05 Jul 1997 23:46:00 -0500 — source: Informix-list mailing list archive (1991-1998)

Nope. This is a "feature". I think it sucks. gm. p.s. BTW, trace really slows things down under v7.x (but not v5...), so don't bother measuring the performance of anything where trace is on. Yes. I think this sucks too. Jeff Craig wrote: > > I am trying to track the number of updates completed > by a stored procedure in a given time period, so I > tried to do the following: > > ...snip > > SET DEBUG FILE TO '/tmp/trace.log'; > TRACE OFF; > > TRACE ":" || CURRENT || ": " || UpdateTotal || " rows updated so far..."; > > ...snip > > The TRACE is getting written out, but CURRENT isn't getting the current > time, merely reports the time the procedure started. > > Is there anyway to output the actual current time? > > Thanks! > > ------------------------------------------------------------------- > Jeff Craig | dbINTELLECT Technologies, Inc. > Senior Consultant | Golden, CO > | (303) 275-6954 ext. 8008 > | email: settler@dbintellect.com > | fax: (303) 275-2134 > -------------------------------------------------------------------