Re: Create Function on Informix 7.3
Posted in 2004
Enor Mouspenis — — source: Usenet: comp.databases.informix
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