Re: functions as SPL's
Posted in 1998
On Tue, 20 Oct 1998, aurelio wrote:
> I have tried to declare a function, but I receive a syntax error. I need
> to return values, so it would be more corret using functions, instead
> procedures. Although I can do it with procedures. Doesn't exists this
> statement (CREATE FUNCTION -- END FUNCTION) ?
CREATE FUNCTION does exist in the IUS-based servers.
> I am using SQL for Dynamic Server 7.3 (Unix).
It doesn't exist in the non-IUS (UDO) servers. Use PROCEDURE instead,
which can return values -- for instance, see the example stored procedure I
posted y'day for selecting the name of the current database.
Yours,
Jonathan Leffler (jleffler@informix.com) #include <witticism.h>
Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN
Informix IDN for D4GL & Linux -- http://www.informix.com/idn