Re: Current function within a Stored Procedure.

Posted in 1998

Guido Conrad — Tue, 23 Jun 1998 11:06:30 +0200 — source: Informix-list mailing list archive (1991-1998)

Hi John, I had the same problem and contacted INFORMIX support for that. The behaviour you noticed is correct, because a stored procedure is an elementary function in SQL and for that reason the CURRENT value has to remain unchanged within that function. Compare to an UPDATE stock SET delivery_date=CURRENT with a number of 10000 records. Each record has to have the same timestamp and should not be evaluated record by record. This was implemented by INFORMIX for stored procedures too.