Hello Rick,

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

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

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

RR> Is there any way to get a real CURRENT_TIME from within a SP?
Yes, use 'NOW' instead. Note that it is string literal, so you have to
put single quotes around, like
insert into tbl(DateTimeField) values('NOW');
or
DateTimeVar = 'NOW';


HTH
--
Best regards,
Pavel Menshchikov
http://www.ls-software.com