#DateForumTypeThreadPost
1309 Oct 2012 @ 05:01 PDTGeneralTopicHow to delete my account in this forumFor some personal reasons I would like to delete my account. Pls help
1209 Oct 2012 @ 04:59 PDTDatabaseTopichow to delete my accountHi ,   For some personal reasons I would like to delete my account . How can I do that?
1107 Aug 2012 @ 12:33 PDTDatabaseTopicMissing record on loading table with Fastload Hi, I have a .txt file which is pipe separated and it has 543895 rows. Duplicate records are avoided by putting a serial number at the end of every row. Its UTF-8 encoded. On runnin...
1007 Aug 2012 @ 12:21 PDTToolsReplyfastload script insert phase error. But I'm getting a  unique issue...I have 543895 records and only 543894 are getting loaded into my table using fastload.      Total Records Read &nb...
906 Aug 2012 @ 04:54 PDTToolsReplyfastload script insert phase error. Hi,   I have had a similar issue, and adding an Enter after the last record  solved it .   Thanks!
803 Aug 2012 @ 01:14 PDTDatabaseReplyFailure 2620 The format or data contains a bad character Can anybody help me with this error pls ...
703 Aug 2012 @ 01:13 PDTDatabaseTopicFailure 2620 The format or data contains a bad character SELECT TRIM((CASE WHEN mt.Store_state IS NULL THEN '#@@#' ELSE mt.Store_state END)) as Store_State ,TRIM((CASE WHEN mt.Company_Cd IS NULL THEN '#@@#' ELSE mt.Company_Cd END)) ...
613 Jul 2012 @ 05:13 PDTDatabaseTopicIF condition in bteq Is the IF THEN ..END IF; syntax correct in Teradata?   
512 Jun 2012 @ 10:24 PDTDatabaseTopicFailure 3568 Cannot nest aggregate operations   Hi,   I have a problem with this part of my code:   (SUM(CASE WHEN PII.O_Id IS NULL THEN  (CASE WHEN PII.B_Qty< 1 THEN (ZEROIFNULL(ABS(PII.B_...
402 May 2012 @ 01:31 PDTDatabaseTopicQUERY TUNING   Hi, I have a query that picks up different columns from different tables by joining them . INNER Join and LEFT outer join are used . 7 tables are used. Now, the query gives me spo...
302 May 2012 @ 12:00 PDTTrainingReplyWant Teradata SQL Tutorial Hi, I too need some good materials for my preparation.Could you please mail them to anjuanish87@gmail.com   Thanks, Anju
216 Apr 2012 @ 05:33 PDTGeneralTopic Target row updated by multiple source rows   update T1  from (Select ipic.invoice_id,ipic.Condition_Type_Cd,ipic.Item_Amt,ipic.item_nr        from T2 ipic       WHERE ipic.Invo...
110 Apr 2012 @ 03:02 PDTGeneralTopic"The string contains an untranslatable character"   Hi all,   I am trying to combine multiple rows into a single row,and in the process I created a global temporary table info_v. But Im getting error in this part: &nbs...