Re: SLP stuff

Posted in 1999

Octav Chiriac — Fri, 30 Jul 1999 09:38:24 +0300 — source: Informix-list mailing list archive (1991-1998)

As I know there is no way to do what you are trying to do, i.e. - no dynamic SQL in SPL. Best Regards, Octav On Fri, Jul 30, 1999 at 07:09:10AM +0200, Svend E. Hansen wrote: > Hello Informix Savants > > I am writing a couple of Stored Procedures and I am wondering wheter it > is possible to use a variable, in some form, in the from statement > e.g..: > > SELECT stuff > FROM variable> > I have tried the above but can't seem to find the right way to apply the > variable either by experimentation or documentation. > > The problem I am working on can easily be solved using ESQL/C, but I'd > rather use SPL 'cause the solution is needed on differnt > platforms/versions. > > Thanks & Best Regards > Svend -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 22 84 88 Moldova, Republic of mailto:com@netinfo-moldova.com