I was trying to track the internal progress of a SP that was running
quite slow.

I created an external table, then wrote to the table at various
points from within the SP and updated using CURRENT_TIME and a note
field. Of course, as I later learned from the documentation the
CURRENT_TIME was set at the beginning of the SP and never
incremented.

I finally figured out what was causing the slow processing, but I
would like to know for the future if something like this is
possible. I tried to Google, but only got information as to why it
doesn't work.

Is there any way to get a real CURRENT_TIME from within a SP?

Thanks,

Rick

use 'NOW' instead of CURRENT_TIME
Alan