Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 27 Jul 2006 @ 16:10:20 GMT


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


Subj:   Re: Teradata Oracle UDF's
 
From:   Dieter Noeth

Victor Sokovin wrote:

  My guess is that the NCR developers have left some of their tools and intermediate results there. Happens even to surgeons sometimes, especially when they have to work under pressure.  


:-)


  Based on this guess I would think that oreplace1.c should actually be the end product they had in mind because it is a result of some translations in oreplace2.c.  


Just open the files:

     replace.sh is a leftover shell script, but oreplace1.c is needed for
     "Function Name Overloading".

     REPLACE FUNCTION oreplace(
         Str VARCHAR(512),
         aFrom VARCHAR(512),
         aTo VARCHAR(512)
     )RETURNS   VARCHAR(512)
     LANGUAGE C
     NO SQL
     SPECIFIC oreplace2
     EXTERNAL NAME 'CS!oreplace2!C:\Teradata\UDF_source\OracleFunctions\replace\oreplace2.c'
     PARAMETER STYLE SQL;

     REPLACE FUNCTION oreplace(
         Str VARCHAR(512),
         aFrom VARCHAR(512)
     )RETURNS   VARCHAR(512)
     LANGUAGE C
     NO SQL
     SPECIFIC oreplace1
     EXTERNAL NAME 'CS!oreplace1!C:\Teradata\UDF_source\OracleFunctions\replace\oreplace1.c'
     PARAMETER STYLE SQL;

Overloading is used quite a lot, e.g 9 different versions of the least/greatest funtions are implemented...


Dieter



     
  <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: 15 Jun 2023