Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Enhancements or Improvements to Stored Procedures
From:   David Clough

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


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020