Re: DROP TABLE Problem
Posted in 1998
Paolo Agati — — source: Informix-list mailing list archive (1991-1998)
Thanks a lot for the answers. A viable solution has been shown by
Art Kagel:
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
Paolo