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>>

Attachments

Library

Quick Reference