Re: functions as SPL's

Posted in 1998

Octav Chiriac — Tue, 20 Oct 1998 20:02:42 +0300 (EETDST) — source: Informix-list mailing list archive (1991-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) ? >I am using SQL for Dynamic Server 7.3 (Unix). > >Thak you. > > CREATE PROCEDURE myprc() RETURNING CHAR(20); ... END PROCEDURE As I know there are no CREATE FUNCTION statements in 7.3. Hope it helps, Octav -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com