Pls help, for TeraData function

Third Party Software
Enthusiast

Pls help, for TeraData function

We will generate some reports from TeraData, due to the business logic is too complex, we may need to create function in TeraData, and use them as below:
select function(V_DIM_ACCOUNT.Acct_Num) from V_Dim_Account;
As I can see now, TeraData seems don't support using SQL to write function but procedure, but procedure can't fit our requirement because I can't use it in a simple select sql. Is there anyone have writen any functions in Teradata before, can you send some samples to me about this?
1 REPLY
Enthusiast

Re: Pls help, for TeraData function

Hi,

For availing the teradata function you have to write the function in C language. as of now i know my knowledge in teradata says