RE: Create Function IDS2000
That looks like dynamic SQL, which you can do directly,
get a copy of Paul Brown Dynamic SPL blade and it will
sort it for you
Paul Watson #
WF Software Ltd # All answers are
+44 1435 674629 # pure fantasy
+44 1436 678693 #
www.wfsoftware.com/informix #
> -----Original Message-----
> From: Felice Caccamo [mailto:felice_caccamo@yahoo.it]
> Sent: Wednesday, November 15, 2000 01:39
> To: informix-list@iiug.org
> Subject: Create Function IDS2000
>
>
> Hi Everybody,
>
> I'm tring to create a particolary Fuction.
>
> its duty is this:
>
> CREATE FUNCTION funct1 (nometab)
> RETURNING char(2);
> CREATE TABLE nometab (colx INT);> RETURN 'OK';
> END FUNCTION;
>
> nometab = function's parameter.
>
> Then I would like to realize a function that will create a table with
> the same name of the
> function's parameter.
> Infact nometab is the function's parameter and when I will
> execute it :
> "execute functl(lavoro)"
> the Informix Server will create a new table lavoro.
>
> Someone know an alternative way to do this ???
>
> Tahnks a lots.
>
> Bye
>
>
>
>
>
>
>
> I would like to know if someone know if
>