All Forums UDA
Krish1124 2 posts Joined 07/07
06 Jul 2007
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.ThanksKrish

joedsilva 505 posts Joined 07/05
07 Jul 2007

That's probably your TTU version, not DBC .....And did you use the syntax for creating recursive views ?REPLACE RECURSIVE VIEWMay be if you can post your SQL, it could help.

You must sign in to leave a comment.