Re: spl function returning row type?
You might try to change the define to 'define b smoo;'. Yes, it's even
difficult for the Informix tutorial writers har har har.
Eric Davies wrote in message <35217337.6024415D@barrodale.com>...
>Hi,
>
> I've tried to write a trivial spl function that returned a row type,
>as below:
>
> create type smoo (a integer, b integer);
> create function smoo2() returning smoo ;> define b smoo;
> let c.a = 3;
> let c.b = 5;
> return c;
> end function ;
>
>when I try to execute the function from dbaccess,
> execute function smoo2();>I get the following message:
> # 696: Variable (c) has undefined value.
>
>As far as I can see, my function varies little from one in the tutorial.
>
>Can anybody shed some light?
>
>Eric.
>