#DateForumTypeThreadPost
1125 Aug 2016 @ 02:01 PDTToolsReplyZero records are fetching when using where statement in TPTHi,   After using LOCK TABLE MY_TABLE EXCLUSIVE I have an update request Then , I want to add something like RELASE LOCK from MY_TABLE after the update, in case of fail. Is it possible...
1024 Aug 2016 @ 07:44 PDTDatabaseReplyLockingHi, After using LOCK TABLE MY_TABLE EXCLUSIVE I have an update Then , I want to add something like RELASE LOCK from MY_TABLE after the update, in case of fail. Is it possible in Teradata...
924 Aug 2016 @ 07:43 PDTAnalyticsReplyRelease Lock from a TableHi Dieter,   After using LOCK TABLE MY_TABLE EXCLUSIVE I have an update Then , I want to add something like RELASE LOCK from MY_TABLE after the update,  in case of fail. Is it possib...
820 Jul 2016 @ 01:04 PDTAnalyticsReplyMAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504Maybe you just need to group also by course_code ( the field in the partition part)...
711 Feb 2016 @ 02:35 PSTDatabaseReplyExtract VS INTERVALHello everyone,   Thank you :-)   Ghalia
610 Feb 2016 @ 08:31 PSTDatabaseTopicExtract VS INTERVALHello,   I want to rewrite this condition : where  ((extract(month from ID_JOUR) between extract(month from (add_months(date,- 2))) AND extract(month from (add_months...
514 Jan 2016 @ 01:18 PSTDatabaseReplyComparing two tablesHello, Please i just want to verify that i well understood :  you are saying that NOT EXISTS is better  than MINUS / MINUS ALL , that's it ? Can you give me more details please ? &...
406 Jan 2016 @ 08:55 PSTDatabaseTopicPrimary indexesHi everyone, Can we have more than one primary index on a table ?   Regards,   Ghalia
330 Dec 2015 @ 06:47 PSTDatabaseReplyLEFT OUTER JOIN ERRORHi Dieter, I am just still curious to know if there is any impact on the performance by using one of them ? In term of performance which one is the best ?  I took the one i posted from a samp...
228 Dec 2015 @ 09:42 PSTDatabaseReplyHow to write (CURRENT DATE - 1 YEAR) in teradata?Hello,   In Teradata 14.10 , it works great just like this : SELECT CURRENT_DATE- INTERVAL '1' YEAR ! Is it still bad to use it like this ?   Regards,   Ghalia
128 Dec 2015 @ 08:16 PSTDatabaseTopicLEFT OUTER JOIN ERRORHello,   I am triying to make this request work :   SELECT * FROM user11__employee emp LEFT OUTER JOIN user11__customer cust LEFT OUTER JOIN user11__department dept ON emp.emp...