RE: Create Function IDS2000
Posted in 2000
Forgot to add you can't drop tables in the PB's
Dynamic SPL blade.
You'd think he'd beable to manage something as trivial as that
wouldn't you :-)))
Paul Watson #
WF Software Ltd # All answers are
+44 1435 674629 # pure fantasy
+44 1436 678693 #
www.wfsoftware.com/informix #
> 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.