|
|
|
Forum Newbie
Group: Forum Members
Last Login: 2 days ago @ 5:07:34 AM
Posts: 5,
Visits: 16
|
|
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?
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/25/2008 11:36:24 AM
Posts: 5,
Visits: 22
|
|
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
|
|
|
|