Re: DROP TABLE Problem

Posted in 1998

Art S. Kagel — Wed, 01 Jul 1998 12:37:55 -0400 — source: Informix-list mailing list archive (1991-1998)

Paolo Agati wrote: > > I'm running Informix SE 7.22 on SCO OpenServer 5.0.4. I want to remove > a set of table from a database and I want to use a stored procedure. This cannot be done in a stored procedure as a general purpose function. You cannot use the contents of a host variable in place of a tablename. You also cannot build a DELETE statement in a string an prepare it in a stored procedure. The only chance might be to build the string into a shell command to pipe the command back into another dbaccess session. Never tried it but the idea has promise. Art S. Kagel