#DateForumTypeThreadPost
1204 Apr 2014 @ 12:10 PDTDatabaseReplyVolatile table vs views.Hi Santanu,   Thanks for your reply. Yes,i need intermediate tables to use them further in my code before inserting the data in my final table.   Regards, Prateek
1101 Apr 2014 @ 01:33 PDTDatabaseTopicVolatile table vs views.Hi, Can some one please tell me, between Volatile table and view, which is better in terms of efficiency, accessbility and use? What is the difference between them?? Also, can I create a volatil...
1021 Jan 2014 @ 11:00 PSTDatabaseReplyWhich is efficient?Thanks Sanatanu. Yes it was a typo, i intended to join these tables on x4 only. :)
921 Jan 2014 @ 10:18 PSTDatabaseTopicWhich is efficient?I have written a query as follows : select a.x1, a.x2, b.x3 from (select x1,x2,x4 from table1 where 'some conditions') as a inner join (select x3,x4 from table2) as b on a.x3=b.x3...
816 Dec 2013 @ 06:17 PSTConnectivityReplyConnecting to Teradata.netHey thanks man, it worked. Can I write this in my .bat file and run a code?
712 Dec 2013 @ 06:33 PSTConnectivityTopicConnecting to Teradata.netI want to connect to teradata.net via batch file. Version of teradata i am using is 13.10, i don't know whether it has bteq enabled or not? Also i have tried sqla -c DBNAME [[\userid]\pwd] and...
625 Nov 2013 @ 12:42 PSTDatabaseReplyAutomate my Teradata queriesThanks guys, this was helpfull. :)
524 Nov 2013 @ 11:37 PSTDatabaseReplyAutomate my Teradata queriesHey, thank for replying. Can you please elaborate a bit?
424 Nov 2013 @ 10:21 PSTDatabaseTopicAutomate my Teradata queriesHi,   I have some teradata codes which I want to automate. It should be done in a way that they can execute themselves on a specific date/time of a month.  Any help will be appreciated...
329 Aug 2013 @ 12:20 PDTDatabaseTopicIs this the casting error?Hi, I am trying to write some SAS codes in Teradata. There is one condition in my code : avg_depth>0 So, the thing is when I am removing this condition from SAS and Teradata, the results are ...
226 Aug 2013 @ 10:52 PDTDatabaseReplyLooping in Teradata sqlDieter, I was using this snippet of code for the purpose of bucketing. There are 20 different buckets and I have to perform 20 different actions for them based on some conditions.   Thanks
123 Aug 2013 @ 07:41 PDTDatabaseTopicLooping in Teradata sqlHi, I am a beginner for Teradata. I am trying to convert following SAS code in sql. DO i=1 to 20 BY 1 IF (x>i/y) THEN DO Z It seems there are no loops available in sql. Any help would be ap...