#DateForumTypeThreadPost
1230 Jul 2015 @ 08:31 PDTDatabaseReplyCumulative BITOR  Minor correction in the output ...sorry about that.. SR value  BITOR_OP 1    1      BITOR(1,0)=1             1    6 ...
1130 Jul 2015 @ 08:30 PDTDatabaseTopicCumulative BITOR Hi, I want to write a sql which will help me find cumulative bitwise OR values as shown below - Most of the cumulative functions use SUM, AVG, MIN, MAX but I could not find a proper so...
1018 Jun 2015 @ 09:34 PDTDatabaseReplyExecute Macro from Stored Procedure???Hi Dieter,  Can you help me with the syntax of calling procedure from macro.    When I am trying to do the same - it says -  5497   CALL cannot be submitted in ...
930 Apr 2015 @ 04:50 PDTDatabaseTopicQuery PerformanceHi, i have T1 table which is very huge, say ~500gb. I have around 5 more tables which are relatively small , say around 5-10gb each..i need to tune a query which is doing sel all columns from T1 l...
803 Apr 2015 @ 09:56 PDTDatabaseReplyGrant users to execute DML on their own tablesThanks Deter, you simply rock ! thank you for such a simple solution.    Regards Abhishek
703 Apr 2015 @ 12:02 PDTDatabaseTopicGrant users to execute DML on their own tablesHi All,   We have a temporary database where many adhoc users have write access i.e ability to create, drop , DML , select access. Howeevr we want adhoc users can ONLY write on tables creat...
602 Apr 2015 @ 07:22 PDTDatabaseReplyhex to char conversionHello ,   Just wondering, if you got a resolution as I am facing the same problem now.   Thanks Abhishek
502 Apr 2015 @ 07:20 PDTDatabaseTopicHex to Char conversionHello  is there a way to convert hex to char in teradata ? I understand this is a way but it onyl works when values are hardcoded, not when the source is a column value.  SELECT &nb...
427 Mar 2015 @ 06:58 PDTViewpointTopicCPU consumption report by virtual partitionHello Under workload monitor, TASM shows CPU consumption report by virtual partition for last 1 min, 10 mins, 30 mins and 60 mins. However , I need to find a report which will show the total cpu ...
318 Mar 2015 @ 02:27 PDTGeneralReplyReverse engineer rules from dbqlruletbl rowsHi Dieter, Apologies, please disregard my last post, it seems i misunderstood . I got it.Its working fine.   Thank you so much.   Abhishek
218 Mar 2015 @ 02:23 PDTGeneralReplyReverse engineer rules from dbqlruletbl rowsAwesome, Thanks a lot Dieter, for your help. Yes I am also using TD 14.10.03.04. But it looks like I had to comment out below columns as it did not exist in DBC.DBQLRule table : Does that look f...
117 Mar 2015 @ 11:25 PDTGeneralTopicReverse engineer rules from dbqlruletbl rows Hello,   We have an existing query logging parameters set for every account in one of the environments (DBC.DBQLRuleTbl). However, we want to make a small change for a specific ...