Archives of the TeradataForum

Message Posted: Tue, 01 Aug 2006 @ 21:24:10 GMT

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

The reason there are two modules is that oreplace1 takes 2 arguments and oreplace2 takes 3 arguments. They are both installed with the UDF Name oreplace(), so oreplace() is the name you always use in the DML statement; oreplace1 and oreplace2 are just the names of DLLs (in Windows) that the DBS will load to execute the function, and which one it uses depends on the parameters used in oreplace(). This is called Function Overloading. This is documented in "SQL Reference: UDF and External Stored Procedure Programming".

Note that the EXTERNAL NAME parameter must point to the location containing C code for each part of the function (as specified by the SPECIFIC parameter).

Rolf Hanusa
I/T Strategist, Dell Computer Corporation

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