Create Recursive View

UDA

Create Recursive View

I have been working on a POC to use the Recursive View feature in teradata. we are running v8.0.2. I have had no luck in creating the view, i can run the query dynamically and get results but no luck the other way. Any of you have similar issues or known syntax problems, please advise.

Thanks
Krish
1 REPLY
Enthusiast

Re: Create Recursive View

That's probably your TTU version, not DBC .....

And did you use the syntax for creating recursive views ?

REPLACE RECURSIVE VIEW

May be if you can post your SQL, it could help.