All forum activity

#DateUserForumTypeThreadPost
5784117 Jun 2016 @ 12:10 PDTdnoethDatabaseReplycalculate date errorWell, this is not Teradata related, in fact no database likes that :) When you Explain your query you'll see "unsatisfiable conditions".
5784016 Jun 2016 @ 11:00 PDTTDMGUSERDatabaseReplycalculate date errorThat was a good point. Add_months is more intuitive for me. But the problem was smething more trivial. It seems that teradata does not like bigger date to be placed earlier in a BETWEEN statement w...
5783916 Jun 2016 @ 10:42 PDTdnoethDatabaseReplyInteger to date conversionI don't know who wrote those conversions originally, but it's just a slightly modified version of a astronomical julian day calculation, so you can use  DATE '0001-01-01' + ...
5783816 Jun 2016 @ 10:42 PDTRanjanj4ToolsReplyMacro problem in SQL Assistant 13.0@soumyasin.. thankyou so much .. its working now .. great work :)
5783716 Jun 2016 @ 10:38 PDTdnoethDatabaseReplyAlter table on huge tableComparing pros & cons of Alter, Merge, Insert/Select:   Why don't you use ALTER TABLE to alter a table?
5783616 Jun 2016 @ 06:53 PDTFredDatabaseReplyInteger to date conversionCheck the logic in dbc.UsersV view definition.
5783516 Jun 2016 @ 06:45 PDTFredDatabaseReplycalculate date errorDon't use INTERVAL MONTH arithmetic for this. There is no 2014-11-31 (18 months before 2016-05-31), but ANSI semantics for INTERVAL types only modifies the portion of the date/time value at the...
5783416 Jun 2016 @ 05:19 PDTTDMGUSERDatabaseTopiccalculate date errorI am trying to find out how many people purchased something in last 12, 18 or 24 months starting from 31st May and looking back. But keep getting invalid date error in terdata. What am I doing wron...
5783316 Jun 2016 @ 05:18 PDTToddAWalterDatabaseReplyCopying trillions of data to new tableIt would be good to see the explain.   The number/granularity of partitions does not affect the cost of executing this process (and converting the granularity of the partitioning would be v...
5783216 Jun 2016 @ 05:05 PDTToddAWalterDatabaseReplyAlter table on huge tableI assume that @samir means that they usually do: INSERT SELECT old table to new table Rename old table to save table rename new table to old table drop save table when satisfied that result is ...
5783116 Jun 2016 @ 04:06 PDTpsapnaDatabaseReplyTeradata basic queryHi there, Is there anyone who could provide an idea on how to start writing rules in Abinitio BRE.Any documentation or any link  online that can be used as a  start guide.I am new to thi...
5783016 Jun 2016 @ 04:06 PDTfgrimmerTeradata StudioReplyCode Assist functionality questionsNothing currently to stop it. But we are working on a new Query Manager and I think it will change this behavior.
5782916 Jun 2016 @ 03:24 PDTgrybackViewpointReplyData Labs Installation QuestionIt can be either.   
5782816 Jun 2016 @ 02:19 PDTXKAMILOXIIDatabaseReplySubtracting Timestamps as decimals hoursThanks, Carlos! :)
5782716 Jun 2016 @ 01:45 PDTteradatauser2DatabaseTopicInteger to date conversionHi, I have date in dbc.oldpasswords which is 735960 and 736051. I want to convert it to a date field so that i can read it. The format of this column is - integer format '_,__,__,_9'. I ha...
5782616 Jun 2016 @ 10:55 PDTfeinholzToolsReplyTDCH-TPT InterfacePlease provide your script and version of TPT.  
5782516 Jun 2016 @ 10:42 PDTBlamey4DatabaseReplyTime Difference from previous rowI will try making the changes you listed to see if it works, thank you for your help!!!
5782416 Jun 2016 @ 10:42 PDTdnoethDatabaseReply'arcmain' utility for Archiving and BackupYep, the TTU Installaton Guides seem to be missing in the 14.10 online docu, but exists for other versions: http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/TTU_Install/B035_3122...
5782316 Jun 2016 @ 10:06 PDTdnoethDatabaseReplyTime Difference from previous rowWhen START_DTE_EVB is a DATE casting to a string with a specific format is simple, either using Teradata's FORMAT or TO_CHAR: TO_CHAR(START_DTE_EVB,'yyyy-mm-dd')   But then...
5782216 Jun 2016 @ 08:27 PDTBlamey4DatabaseReplyTime Difference from previous rowHi Dieter Thank you for helping! In our database the date and time columns seperate columns; The date is data type [DATE] and the time column is data type [VARCHAR (8)] so the time value appears li...
5782116 Jun 2016 @ 07:58 PDThferro@gmail.comDatabaseTopic'arcmain' utility for Archiving and BackupHey all, I am new to Teradata and unable to complete a quite basic task: database backup. After reading the documentation available on line, I understood that the best (free) tool for backup is th...
5782016 Jun 2016 @ 07:33 PDTkmccartyHadoopTopicUsing TDCH Export to move data from Hive view or query into TeradataI have a Hive table that is too big for my Teradata database, but if I can exclude some of the columns, it should be OK.  Since I don't want to have a duplicate copy of the table with fewe...
5781916 Jun 2016 @ 07:14 PDTkmccartyHadoopReplyCan the TDCH be used to load data into view (in teradata)Which TDCH README are you reading?  The only one I can find is the Teradata Connector for Hadoop Tutorial v 1.0 which has nothing of which you speak.
5781816 Jun 2016 @ 06:32 PDTvenkatmummidiToolsReplyTPT and Windows PowerShell Iam get the same error when trying to run tbuild via powershell/java procces builder.   Error launching tbuildexe.exee": The system cannot find the file specified.  (2...
5781716 Jun 2016 @ 06:15 PDTraf_vandormaelDatabaseReplyTeradata DBQL logging setup and maintanence document for TD 15We currently are still in 14.10 and plan to go to 15.10. Today we archive our DBQL / resusage data to a database we've created ourselves. It's named is certainly not PDCR. * How generic is...

Pages