Can a table UDF modify SQL data?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mailar@gmail.com - 19 Jan 2005 11:40 GMT

Hi,

I want to write a UDF (external UDF or SQL UDF) that creates a table
adn returns the same to the calling function.
So, Can someone tell me is it possible to create/drop tables from a
table UDF. The UDF can be an external or SQL UDF.
Thanks in advance
mailar

Reply to this Message

Knut Stolze - 21 Jan 2005 11:04 GMT

> Hi,
>
> I want to write a UDF (external UDF or SQL UDF) that creates a table
> adn returns the same to the calling function.
> So, Can someone tell me is it possible to create/drop tables from a
> table UDF. The UDF can be an external or SQL UDF.

Have a look at procedures. Most likely this is what you want to use in the
first place.

Signature

Knut Stolze
Information Integration
IBM Germany / University of Jena

Reply to this Message