Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mark Denham — — source: Informix-list mailing list archive (1991-1998)
>I am exploring using SPL to store functions that preform specific tasks and
>return a result. These fuctions i currently store in a library. I am
>hoping that by making them SPL code that I can save the time a 4GL uses to
>verify the SQL's involved in the task. What i am having trouble doing is
>getting the SQL procedure to execute and return a value.
>sample code block that i am currently trying:
>main
>define v float
>define s char(40)
>let s = "execute procedure p() into v"
>prepare e_SPL from s
>execute e_SPL
>display v
>end main
>help!
>thanks
I think you will find that the only way this works (at least with 4.12 or
earlier) is as follows:
define v flaot
prepare e_SPL from "execute procedure p()"
declare e_SPLcur CURSOR FOR e_SPL
foreach e_SPLcur into v
.....
end foreach
Mark Denham
BBC
London, UK
Mark.Denham@bbc.co.uk
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.