How to Create Table Value Function in Teradata

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Fan

How to Create Table Value Function in Teradata

Hi , I have MS SQL Table valued funcation which returns the table from the funcation. I wanted to replicate the same in Teradata but I m not sure which option i should . Please suggest me.

 

Thansk In Advance

Naga


Accepted Solutions
Highlighted
Ambassador

Re: How to Create Table Value Function in Teradata

Teradata doesn't support SQL Server's TVFs written in SQL.

There are Table Functions and Table Operators, both returning a table, but they're must be written in C/Java.

 

Can you show the source code of your TVF, maybe it's possible to find a workaround?

1 ACCEPTED SOLUTION
1 REPLY 1
Highlighted
Ambassador

Re: How to Create Table Value Function in Teradata

Teradata doesn't support SQL Server's TVFs written in SQL.

There are Table Functions and Table Operators, both returning a table, but they're must be written in C/Java.

 

Can you show the source code of your TVF, maybe it's possible to find a workaround?