Re: Create Function IDS2000
Posted in 2000
From: Felice Caccamo <felice_caccamo@yahoo.it>
>
>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.
I'm not sure if it will do the job, but there's a Dynamic SPL DataBlade at
http://www.iiug.org that might help.
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.