Archives of the TeradataForum

Message Posted: Fri, 30 Jan 2004 @ 14:59:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Everyone:

I am not sure what you are referring to as a UDF to mimic a REPLACE function. If it is to replace some sort of data with another, then yes, UDFs are really good. But if it is meant to actually "replace" Teradata objects, then no, UDFs cannot do that. They cannot execute any SQL. They may be able to prepare SQL text which could be emitted and subsequently executed by something like BTEQ or SQL Assistant to replace an object, but why would you do that.

I did present UDFs at Partners and mentioned the list of about 70 PS provided UDFs. Contact your local Professional Services Representative to determine how these are best provided in your region.

Cheers

Jim Calvert - Teradata

	<Prev	Next>		<<First	<Prev	Next>	Last>>