Hi,

> As for the external file name, I prefer not to touch system tables as
> administrator privileges are required, and there might be
> other restrictions
> as well. This leads me to think if it is possible to create
> the table from
> within a stored procedure with a CREATE TABLE that has the
> required filename
> passed as a variable. Is that possible?. And what if the
> table has triggers?
> Is it possible to define triggers as well from withing a
> stored procedure
> (because I suppose we cannot drop and create a table without
> dropping its
> triggers first)?

DDL statements are not allowed in stored procedures and triggers. So you
cannot use CREATE TABLE or whatever else. Sad but true.

Cheers,
Dmitry