#DateForumTypeThreadPost
9728 Jul 2014 @ 05:21 PDTDatabaseReplyESCAPE with Single Quote ?Try this sel * from db.table where field like '''TEST''%' ; Thanks Santanu
9628 Jul 2014 @ 04:47 PDTDatabaseReplyDistribution in ampsHi When you create a table, table header is created across all amps. It consumes 1024 B for that. Thanks Santanu
9527 Jul 2014 @ 11:15 PDTDatabaseReplyViewpoint and Corresponding DBC TableHi Anyone, any guidance ? Santanu
9423 Jul 2014 @ 06:27 PDTDatabaseTopicViewpoint and Corresponding DBC TableHi In Viewpoint Query-Monitor, for a particular session we can check the cpu skew and also the highest and average cpu. If I want to check this from database, then which table and column shall I ...
9319 Jun 2014 @ 09:33 PDTToolsReplyTPT Load Operator Table LockHi Steve Any suggestion? Thanks, Santanu
9218 Jun 2014 @ 11:01 PDTToolsReplyTPT Load Operator Table LockHi Steve and Q Thanks for your reply. Actually I have a scenario and I want to know the best possible solution. We have many stage tables where truncate load is happening everyday with almost 1M ...
9118 Jun 2014 @ 10:38 PDTDatabaseReplyLock OverrideHi Fred Thanks for your reply. Yes, I meant all PI cols. Santanu
9018 Jun 2014 @ 12:12 PDTToolsReplyTPT Load Operator Table LockHi Steve Thanks for your reply. I can understand what you are saying. But I was thinking, if I go for drop and recreate of table every time, this will take Exclusive lock across all amps. If I am...
8918 Jun 2014 @ 12:05 PDTDatabaseReplyLock OverrideHi Fred Thanks for your reply. Just to summarize my understanding, even if I am using a VIEW with LOCKING ROW FOR ACCESS, 1. If it is Update with PI value, it will be Row-hash Write lock 2. If i...
8816 Jun 2014 @ 11:13 PDTDatabaseReplySQL to get first day of month and last day of month but for 2 months agoHi Please try below query. SEL ADD_MONTHS((DATE - EXTRACT(DAY FROM DATE)+1), -2) BOM , ADD_MONTHS(LAST_DAY(DATE),-2) EOM ;   Thanks Santanu
8716 Jun 2014 @ 11:03 PDTDatabaseTopicLock Override Hi Dieter / All   I would like to know one thing.   There is one table T. A view V is created with LOCKING ROW FOR ACCESS. Now, 3 different users (in 3 different se...
8616 Jun 2014 @ 04:41 PDTToolsTopicTPT Load Operator Table LockHi All I want to know one thing. I submit one TPT Load job. If the job fails the target table will be locked (similar to fastload). Both are valid, but what is the better remedy? use Standalone ...
8511 Jun 2014 @ 10:36 PDTGeneralReplyOREPLACE gives an error, how to confirm its availableHi oreplace function is part of td_sysfnlib database and it comes as part of TD 14. Thanks Santanu
8411 Jun 2014 @ 10:24 PDTGeneralReplywhich to pick for multi-column stats ?Hi Raghu You may find your answer in the below link. http://developer.teradata.com/blog/carrie/2013/02/statistics-collection-recommendations-teradata-14-0   Thanks Santanu
8311 Jun 2014 @ 05:03 PDTDatabaseReplyneed syntax for for last 2 years dataThanks Dieter for your answer and clarification. Santanu
8211 Jun 2014 @ 02:13 PDTDatabaseReplyneed syntax for for last 2 years dataHi Dieter Want to know your opinion. While calculating last day of month, does the use of add_months better option than last_day function? Is there any restriction on last_day function? Thanks S...
8111 Jun 2014 @ 01:17 PDTDatabaseReplyneed syntax for for last 2 years dataThis could be helpful for your reference. SEL DATE - EXTRACT(DAY FROM DATE) + 1 FIRST_DAY, LAST_DAY(DATE) LAST_DATE ; Thanks Santanu
8011 Jun 2014 @ 12:45 PDTDatabaseReplyDBQLFlushRate under 60 secWell, I never tried to reduce the flush rate, but one thing is sure, such logging rate will impact capacity. Thanks Santanu  
7908 Jun 2014 @ 10:56 PDTDatabaseReplyConcatenate AND aggregate row values to columnsHi This may be helpful. CREATE MULTISET TABLE TABLE2 ( CUSTOMER_ID INTEGER, PRODUCT_CODE VARCHAR(20), PRODUCT_PRICE DECIMAL(5,0) ) NO PRIMARY INDEX ;   ...
7808 Jun 2014 @ 10:21 PDTDatabaseReplyneed syntax for for last 2 years dataThanks Dieter for your update. Now I can see, SEL DATE '2016-02-29' - INTERVAL '4' YEAR ; will work but SEL DATE '2016-02-29' - INTERVAL '2' YEAR ; will n...
7706 Jun 2014 @ 04:33 PDTDatabaseReplyConcatenate values from one field in multiple rows into one one field on all rowsHi This is how, I would do it. Hope this will be helpful. Someone may have a better option. CREATE MULTISET TABLE TABLE2 ( PARENTID INTEGER, CHILDID VARCHAR(20), LOCATION VARCH...
7606 Jun 2014 @ 03:36 PDTDatabaseReplyGroup By an Partition by in a single queryHi These are my thoughts. Since you are aware of group by and partition by, I am not going in much details. The above query should run. But if you change it to    SEL COL1,COL2,COL3...
7505 Jun 2014 @ 11:40 PDTDatabaseReplyFailure 2673 The source parcel length does not match data that was defined.Good to hear that it has worked. You are right, the 2nd option is not required. Just one curiosity , are you using TD 14 ? Thanks Santanu
7405 Jun 2014 @ 09:45 PDTDatabaseReplyPerformance of Correlated Subquery!!!Hi Nicely done. This will definitely be helpful for anyone seeking the answer. Thanks Santanu
7305 Jun 2014 @ 06:46 PDTDatabaseReplyPerformance of Correlated Subquery!!! Hi   Please refer the below example.   CREATE MULTISET TABLE EMP_TAB ( EMP_ID INTEGER NOT NULL, EMP_NAME VARCHAR(10), EMP_DEPT INTEGER ) UNIQUE ...

Pages