Archives of the TeradataForum
Message Posted: Thu, 26 Jul 2007 @ 13:30:00 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|