#DateForumTypeThreadPost
2217 Apr 2012 @ 12:27 PDTDatabaseReplyCounts and total count in one query ?   id date_d Sum(CAT1) Sum(CAT2) Sum(CAT3) Sum(total) 12 1/2/2012 3 ...
2117 Apr 2012 @ 12:25 PDTDatabaseReplyCounts and total count in one query ? small modification for the above query brings me the expected out put. Thank you karthik . and Sorry for the delay in updating the post .. CREATE VOLATILE TABLE main (catg VARCHAR(6), co...
2001 Mar 2012 @ 07:03 PSTDatabaseTopicCounts and total count in one query ? Hi ,   How to display count and sub counts in select query itself ? source data set : table 1 : cat1 = 101 cat2 = 102 cat3 = 103   table 2 : Id&...
1917 Feb 2012 @ 10:03 PSTDatabaseReplyRequire sql query for this issue. Hi ulrich, can you please elaborate the query .. i am confused with this miN(start_dt) over (partition by POL_ID order by start_dt rows between \ 1 following and 1 following) - end_dt ...
1817 Feb 2012 @ 06:53 PSTDatabaseTopicRequire sql query for this issue. CREATE MULTISET VOLATILE TABLE REQ_QUERY (   POL_ID VARCHAR(20) , START_DT DATE FORMAT 'YYYY-MM-DD' , END_DT DATE FORMAT 'YYYY-MM-DD' ) ON COMMIT PRE...
1703 Jul 2011 @ 08:59 PDTDatabaseReplySome Problem with Bteq !!!! need help
1601 Jul 2011 @ 04:30 PDTDatabaseReplySome Problem with Bteq !!!! .logon *** Logon successfully completed. *** Teradata Database Release is 12.00.03.18 *** Teradata Database Version is 12.00.03.18 *** Transaction...
1530 Jun 2011 @ 11:29 PDTDatabaseTopicSome Problem with Bteq !!!! hai Friends , Please kindly help me in resolving the issue . I have written a Bteq Script ... which is having few inset dmls and one update dml for a particular table . when i execute the ...
1424 May 2011 @ 11:16 PDTDatabaseTopicUTY4017 Not enough data in vartext record number 1Target Table : xyz CO_ID VARCHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC, CLI_ID VARCHAR(11) CHARACTER SET LATIN NOT CASESPECIFIC, Mload Script : .LAYOUT L_ins ; .FIELD CO_...
1323 May 2011 @ 05:23 PDTDatabaseReplyAn Bteq Error Code return issue.Need HelpThe information in the link provided is pasted below... The results are stored in a pseudo environment variable named errorlevel so... echo Exit Code is %errorlevel% and a special syntax o...
1222 May 2011 @ 05:44 PDTDatabaseTopicAn Bteq Error Code return issue.Need HelpHai friends, Hope your are doing good . i got a issue raised in project reqarding the bteq script . Our environment is teradata on windows platform . i want to capture the bteq script fin...
1128 Mar 2011 @ 11:31 PDTToolsReplySCD type 2Hai anand, You explained SCD Type 2 method with example very well . but how to implement the same in Mload script ? already i checked this solution given in the below link . http://forums.teradata...
1028 Mar 2011 @ 11:28 PDTToolsReplyscd type 2 in mloadhai bab, The Above code doesn't work in implementing SCD Type 2 via MLOAD . Because by giving both "apply lbupdate apply lbinsert" for a new record it will effect both dml labels . for a re...
901 Mar 2011 @ 07:08 PSTDatabaseReplyHow to Control Data Distribution in Teradata ?Thanks Jim , Yes it can be done with NUPI !!!
827 Feb 2011 @ 10:55 PSTDatabaseTopicHow to Control Data Distribution in Teradata ?Hai Friends , Recently is have been asked some one How to control Data Distribution in Teradata ? his intention is that .. if my Teradata database is having 10 Amps , if UPI is created on the col...
727 Feb 2011 @ 10:39 PSTDatabaseReplyInner join on multiple Columns best way?(It's a bit urgent)Hai Anil , i feel emilwu approach is good . But, Can you tell me where in real we need to join on multiple columns ? For example in your project where you got this situation ?
608 Feb 2011 @ 01:42 PSTDatabaseTopicwhat is a Junk Dimension ?Hai Friends , Can anyone help me in understanding the "Junk Dimension" with some example . Thanks in Advance.
507 Feb 2011 @ 11:42 PSTDatabaseTopicDifference between features V2R5,TD12 and TD13?Difference between features V2R5,TD12 and TD13? Hai Teradata Professionals, Please can any one tell me the Differences between the Teradata versions V2R5 -------------- TD 12 ---------------...
410 Dec 2010 @ 09:55 PSTDatabaseReplyHow to retrive the last word in the Sentence in Teradata ?Hai Teradata Professionals, Please someone solve my doubt i am waiting from many days . Thanking you all in advance, kiran
307 Dec 2010 @ 11:29 PSTDatabaseReplyHow to retrive the last word in the Sentence in Teradata ?Hai , Either of the two teradata functions INDEX and POSITION Syntax has NO negative integer option to search for a sub sting from back of the main string . Thanks for responding , Kiran
205 Dec 2010 @ 06:41 PSTThird Party SoftwareReplyBacking up Teradata using Tivoli Storage Manager (TSM)Hai friend, i am interested to know How to take backup Teradata using Tivoli Storage Manager . Could you help me ? Thanks in Advance.
104 Dec 2010 @ 10:23 PSTDatabaseTopicHow to retrive the last word in the Sentence in Teradata ?Hai... i am new to Teradata . my objective is to retrieve the last word in the sentence with out hard coding . i got the sql query in Oracle but don't know how to accomplish the same in Teradat...