Re: SPL and parameters ...

Posted in 2000

Obnoxio The Clown — Mon, 31 Jul 2000 21:14:41 BST — source: Informix-list mailing list archive (1991-1998)

From: "Michel" <michel.peyron@accim.com> > >How can I send a database name to a Stored Procedure in parameter ? > >Something like that : > >create procedure something(database_name char(18)) > select * from database_name:systables;>end procedure You can't do dynamic SQL in SPL, unless you have a 9.x server and the Dynamic SPL bladelet from http://www.iiug.org ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com