TRACE CURRENT in SPL
Posted in 1997
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 -------------------------------------------------------------------