#DateForumTypeThreadPost
424 Jul 2006 @ 10:19 PDTDatabaseReplyProblem with Recursive ViewBelow is the recursive view. It's created and running fine. The problem is with the outer view encapsulating this recursive view. Teradata simply won't let me create it (the outer view). Keep getti...
321 Jul 2006 @ 03:42 PDTDatabaseReplyProblem with Recursive ViewAs a workaround I've created a volatile tableCreate volatile Table B_Temp As (Select *From B) With dataON COMMIT PRESERVE ROWS;And then created the View A based on the B_Temp table.This workaround ...
217 Jul 2006 @ 02:45 PDTConnectivityReplyTeradata ODBC Trouble in MS/AccessI had the same problem. And in add/remove it shows that I already had ODBC 3.04.00. I downloaded the latest ODBC driver, un-installed the old one and install ODBC driver 3.04.00.01. The problem is ...
106 Jul 2006 @ 05:32 PDTDatabaseTopicProblem with Recursive ViewI've created a recursive view (A) using the "REPLACE RECURSIVE VIEW" command. It's working fine.The problem comes when I tried to create a non-recursive view (B) as following:Create View B (id) As(...