Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Roger Tomas — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.