Using Functions in Teradata

Database
Enthusiast

Using Functions in Teradata

Hi,

We have a following query in Oracle pl/sql which uses the following function "func" which accepts parameters and returns a value.

<<<<<<<<<
select func (param_1,param_2,param_3)
from
select
(
column_1 param_1,
column_2 param_2
from
tbl 1
)
>>>>>>>>

As seen above the values sent as param_1 , param_2 are taken from the column_1 and column_2 of table tbl 1.

Can anyone help me out on converting this to Teradata equivalent "function" or any other way of implementing the same.
1 REPLY
Junior Contributor

Re: Using Functions in Teradata

Hi Jaguar,
looks similar to a User Defined Function (UDF) in Teradata, but those must be written in C/C++.

Check the manuals for details or download some example UDFs from teradata.com

Dieter