Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Jul 2007 @ 14:21:20 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Enhancements or Improvements to Stored Procedures
From:   Barry Hull


You don't have to compile the UDF outside of Teradata, but you would want to so that you could test it independently of the database.

When you run the "CREATE FUNCTION" or "REPLACE FUNCTION", Teradata will use the compiler that is on one of the nodes to compile the UDF.

I don't have the exact same compiler version that is on the Teradata node, but for the most part, if it compiles ok with my local compiler, it will compile ok on using the compiler that is on the node.

Good Luck!


Barry Hull
Orange Diamond Consulting, LLC

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