Archives of the TeradataForum

Message Posted: Thu, 26 Jul 2007 @ 13:30:00 GMT

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

I like the idea that Rolf Stegelmann has, whereby data can be written to a Global Temporary table from within a Stored Procedure, involving calling a UDF.

Pardon my ignorance on these things but I've never created one - a UDF, that is. My question is, do you have to compile the C program outside of Teradata and then just name it within the Create Function DDL ? If so, then presumably we would have to compile it to the same box that Teradata is deployed and, added to that, purchase (or download a C compiler). Is that how it works ?

Actually, I do happen to use a similar approach to Rolf - at least, I think it's similar - but without the UDF. I write data (at specified) points in the SP to a permanent table, but only if an Input Parameter (WRITE_AUDIT, say ) is set to 'Y'.

Actually, it appears that the UDF call suffers from the same drawback that my approach does, namely formatting the data into the UDF.

Anyway, Rolf, thanks.

Dave Clough
Database Designer
Express ICS

www.tnt.com

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