#DateForumTypeThreadPost
23724 Aug 2013 @ 07:43 PDTPrivate Forum
23616 Aug 2013 @ 12:25 PDTDatabaseReplyquery on cumulative sum.....Answered here http://forums.teradata.com/forum/database/query-on-csum#comment-80303
23516 Aug 2013 @ 12:23 PDTDatabaseReplyquery on CSUMYou need to use window aggregate function, something like this should work... SEL NAME, MEASURE, DATE, SUM(MEASURE) OVER(PARTITION BY NAME ORDER BY DATE ASC ROWS UNBOUNDED PRECEDING) AS CUM_AMT...
23430 Jul 2013 @ 04:42 PDTPrivate Forum
23304 Jun 2013 @ 11:59 PDTGeneralTopicNew Thread NotificationsHi All, Not sure if I am the only one facing this issue or someone else is experiencing the same problem as well.  I used to receive the email notifications for all the new threads opened no...
23217 May 2013 @ 03:32 PDTDatabaseReplyvolatile table as select..with data - not loading dataON COMMIT DELETE ROWS is the default option set with volatile table syntax. You can mention that explicitly as well, but if you specify this option then you will loose the data as soon as the trans...
23117 May 2013 @ 02:45 PDTDatabaseReplyOracle "REPLACE" function equivalant function in TeradataTeradata now provides the OREPLACE function bydefault, so why not use that?
23020 Feb 2013 @ 03:31 PSTDatabaseReplyCommand Help : Alter table modify columnALTER TABLE to change the datatype of existing columns is very limited. You can use this statement to change the VARCHAR and increase the number of characters but I don't think you can do that ...
22919 Feb 2013 @ 05:19 PSTDatabaseReplyFind new tables created in last monthThere is a DBQLOGTBL you can refer to. See the column QueryText - this contains all the sqls that have been executed. You need to filter out the records by selecting only CREATE and DROP table stat...
22819 Feb 2013 @ 02:12 PSTGeneralReplydb2 DDL to teradata conversionDo you have ERWIN? You can import the DB2 table DDLs using reverse engineering and then can export in Teradata DDLs. I haven't tried it myself but its worth giving a try...
22719 Feb 2013 @ 01:30 PSTDatabaseReplyNeed SuggestionsThis is logical. If there is one value in lookup table and there are 15 values in joining tables then you get the 15 records. If you need only single record from the main table then you can use th...
22619 Feb 2013 @ 12:59 PSTDatabaseReplyFind new tables created in last monthThat is correct because data dictionary keeps track of what exists in the DB. Once the tables are dropped the dictionary entried are removed. If you want to keep an AUDIT of tables then probably y...
22516 Feb 2013 @ 01:31 PSTDatabaseReplyIndex Cocepts in TeradataIts the same reason as explained in the thread above. Which part you don't understand?
22413 Feb 2013 @ 05:22 PSTToolsReplyMultiload and partitioned tableHi Dieter, You are right. My bad! :)
22313 Feb 2013 @ 12:54 PSTToolsReplyMultiload and partitioned tableYou can't use multiload on a column partitioned table... You can either use TPUMP or load into a non-column partitioned table and then do INSERT/SELECT into the target table.
22211 Feb 2013 @ 11:39 PSTDatabaseReplyDefault Value for a Data Columnhttp://forums.teradata.com/forum/database/default-value-for-a-date-column#comment-25994
22111 Feb 2013 @ 11:35 PSTDatabaseReplyDefault VAlue for a Date ColumnThe syntax defining the default date value is wrong, use the keyword DATE after DEFAULT keyword... Following post will help you! http://forums.teradata.com/forum/database/create-a-table-with-...
22011 Feb 2013 @ 11:31 PSTDatabaseReplyAudit process after the DRI Load completesThis forum is to help the people facing certain problems and solve their issues, not to provide the solutions for business requirements. The best way would be to write the script yourself and post ...
21911 Feb 2013 @ 11:17 PSTDatabaseReplyIs numeric data type available in TD ? duplicate post...
21811 Feb 2013 @ 11:15 PSTDatabaseReplyIs "numeric" data type available in TD ? Regarding your second question... GO is generally used as as batch separator in a script which ensures that the all the SQL before the GO statement will finish before proceeding further. Semicolon ...
21711 Feb 2013 @ 11:03 PSTDatabaseReplyIs "numeric" data type available in TD ? In Sybase I believe NUMERIC datatype is same as DECIMAL. Teradata has DECIMAL datatype, you can specify the precision and scale for DECIMAL as per requirement. I think NUMERIC(10) should be simila...
21606 Feb 2013 @ 11:50 PSTDatabaseReplyhow to find the start dates from history And If you need the complete record then you can SELECT TBL1.* FROM <<TABLE_NAME>> AS TBL1 INNER JOIN ( SELECT CUSTOMER_ID, MIN(START_DATE) MIN_START_DATE FROM <<TABLE...
21506 Feb 2013 @ 11:14 PSTDatabaseReplyhow to find the start dates from history In your second example there are no customers with start date of 13/11/2011. Anyways, If you just need the minimum start date against a customer then you can do this... SELECT CUSTOMER_ID, MIN(...
21406 Feb 2013 @ 03:03 PSTTeradata ApplicationsReplyQuery to find There have been a lot of similar posts. Please avoid posting multiple times!
21306 Feb 2013 @ 02:52 PSTDatabaseReplyPerformance of MERGE versus SQL INSERTI think in your case the INSERT INTO will be better than MERGE INTO... The later is kind of a two step process where the matching rows are updated while the new ones are inserted, while the former ...

Pages