TRACE CURRENT in SPL

Posted in 1997

Topics: Stored Procedures & SPL, Jobs, Consulting & Announcements

Jeff Craig — 5 Jul 1997 22:08:29 -0400 — source: Informix-list mailing list archive (1991-1998)

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 -------------------------------------------------------------------

Glossary

SPL (Stored Procedure Language)