Re: ARGH - stored procedures
davin_harvey@dsti.co.uk wrote:
>
> Message is sent with MIME. Attachments are base64 encoded
>
> --TFS-with-MIME-and-DIME
> Content-Type: text/plain; charset=ISO-8859-1
> Content-transfer-encoding: quoted-printable
>
> Hi,
> =20
> Is there any way of writing a stored procedure that will drop a table=20
> based on a parameter passed into that procedure? What I want is
> =20
> CREATE PROCEDURE drop_table(tabname CHAR(18))
> DEFINE drop_str CHAR(80);> =20
> LET drop_str =3D 'DROP TABLE ', drop_str;
> EXECUTE IMMEDIATE drop_str;
> END PROCEDURE;
> =20
> except that EXECUTE is not allowed in a stored procedure=2E
> =20
> Any suggestions anyone?
> =20
> Ta
> Davin
>
> **********************************************************************
> DST International Tel:+44 181 390 5000 www=2Edstinternational=2Eco=2Eu=
[cutting]
Dynamic SQL is not allowed is SPL.
--
Paul Watson
WF Software Ltd.
Tel: +44 121 440 3179
Fax: +44 121 440 3806
Email: paulw@wfsoftware.co.uk