RE: Create Function on Informix 7.3

Use create procedure in versions prior to 9.x -----Original Message----- From: Enor Mouspenis [mailto:enormouspenis@hotmail.com] Sent: Wednesday, March 24, 2004 4:04 AM To: informix-list@iiug.org Subject: Re: Create Function on Informix 7.3 Espen Aase Johnsen wrote: > Hi! > > I'm trying to create a function using the statement: > CREATE FUNCTION myDummy( in_str VARCHAR ) > RETURNING VARCHAR > RETURN( in_str );> END FUNCTION > > And I get this message back: > [Informix][Informix ODBC Driver][Informix]A syntax error has > occurred.(-2147217900) > > This statement gives me Owner="7.30C1" > select * from systables where tabname=" VERSION"> > Any ideas? I don't have access to the actual computer running the > database. The odbc is "Informix 3.80.00.10841" I think it is not supported to CREATE FUNCTION in IDS 7, only in IDS 9. -- Enor sending to informix-list

On Wed, 24 Mar 2004 07:42:32 -0800, "Dale Gilbert" <dgilbert@nationalclearing.com> wrote: > >Use create procedure in versions prior to 9.x > Hi. I'm now using CREATE PROCEDYRE foo() RETURNING VARCHAR; It works like a charm, thank you!