Re: TRACE CURRENT in SPL

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? Build a UNIX command string that you then execute using the system call. Something like the following: let command = 'echo "`date`: ' || UpdateTotal || ' rows updated so far..." >> somefile'; system command; I haven't tested this but I've done something similar in the past. ----------- Roger Tomas AG Communication Systems