Re: Re: Current function within a Stored Procedure.

>> Here's a synopsis of the problem I'm trying to solve: >> >> I have a table (table_a) with two datetime columns (start_time, >> end_time). >> >> At the beginning of a stored procedure, I want to insert a row into >> table_a setting start_time to the current datetime. The stored >> procedure then executes a bunch of other statements that take up to >> several hours to execute. At the end of the procedure, I want to update >> table_a end_time to the current datetime (different than the start >> datetime). Because the Informix 'current' function in a stored >> procedure returns only one value, I'm having trouble registering the two >> different times. I seem to recall another function that did exactly what you need, specified as different to CURRENT for that fact. Was it NOW or is my memory playing tricks on me? K e n G i l l e t t ------------------------------------------------------------------------- I N F O T A I N Fern House, Stonehill Road, Ottershaw, KT16 0EW, United Kingdom tel +44(0)1932-879900, fax +44(0)1932-879909 eMail keng@Infotain.com -------------------------------------------------------------------------