get current time in stored procedure

[byrdfarmer]

Hi all. Someone here noticed that if you try to get the current time in a stored procedure, the routine only returns the time when that SP started...trying to add time stamps in different parts of an SP and running into this.

Any suggestions?

 

[mberni]

you could do a system call which writes a log into a separate table

create procedure doit()
returning integer;

DEFINE cmd varchar(255);

LET cmd="insert into mytab values('`date` :I am here')";

SYSTEM 'echo "'||cmd||'" | dbaccess mydatabase';

RETURN 0;
end procedure;