Re: TRACE CURRENT in SPL
}>From ilist@rmy.emory.edu Mon Jul 7 15:19:36 1997 }>Received: from rmy.rmy.emory.edu by hobbes.dbintellect.com via ESMTP (950413.SGI.8.6.12/930416.SGI.AUTO) }> for <settler@dbintellect.com> id PAA00095; Mon, 7 Jul 1997 15:19:34 -0600 }>Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id OAA18658 for informix-list-out; Mon, 7 Jul 1997 14:40:01 -0400 (EDT) }>From: Roger Tomas <tomasr@agcs.com> }>Message-Id: <33C0EC70.4FB9@agcs.com> }>Subject: Re: TRACE CURRENT in SPL }>Date: Mon, 07 Jul 1997 06:17:36 -0700 }>Reply-To: Roger Tomas <tomasr@agcs.com> }>Organization: AG Communication Systems }>Sender: informix-list-owner@rmy.emory.edu }>To: informix-list@rmy.emory.edu }>X-Informix-List-Id: <news.40147> }> }>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 }> Thank you for the suggestion. I had already stumbled on that solution and it works well. May be quicker than TRACE too, based on other posts. ------------------------------------------------------------------- Jeff Craig | dbINTELLECT Technologies, Inc. Senior Consultant | Golden, CO | (303) 275-6954 ext. 8008 | email: settler@dbintellect.com | fax: (303) 275-2134 -------------------------------------------------------------------