All forum activity

#DateUserForumTypeThreadPost
76919 Apr 2006 @ 10:29 PDTBBR2DatabaseReplyweird issue importing from excel to TD.....Mike,You may want to remove all column header information from the export report file. This should help.For the date issue, you will need to change the format to match the date format (for the colu...
76819 Apr 2006 @ 10:25 PDTBBR2DatabaseReplyNumber of weeks in a given month and yearAbdul,You can use the following SELDistinct Year_Of_Calendar (TITLE 'YEAR'),Month_Of_Year (TITLE 'MONTH'),Week_Of_Month + 1 (TITLE 'WEEK') --,Calendar_Date (TITLE 'DATE')FROM sys_calendar.calend...
76719 Apr 2006 @ 10:10 PDTCraig.SchweizerDatabaseReplyWrite/Read external file from within Stored Procedure?Does anyone have an update on this? Should I post in another forum? Please let me know if clarification is needed. Thanks.
76619 Apr 2006 @ 09:30 PDTBBR2ConnectivityReplyTeradata ODBC Trouble in MS/AccessRamesh,You may want to uninstall and re-install the drivers again.New TD ODBC drivers are backward compatiable. I think this should resolve the problem that you are having.Kindly let me know if you...
76519 Apr 2006 @ 03:40 PDTramesh_palaConnectivityReplyTeradata ODBC Trouble in MS/AccessHi vinay,Thankyou. I intalled the TTU8.0 Windows-i386 tdodbc.03.04.00.01. But now i am not able to conect to Teradata. Error:160: Specific Driver could not be loaded due to system error 126 (tera...
76418 Apr 2006 @ 11:09 PDTBBR2ConnectivityReplyTeradata ODBC Trouble in MS/AccessYou may want to download latest ODBC patch from Teradata Website.I think TTU8.0 Windows-i386 tdodbc.03.04.00.01 downloadable should resolve your problem.Vinay
76318 Apr 2006 @ 08:20 PDTJohn MacDatabaseTopicINTEGER/BYTEINT accumulation and presentationComrades !I ran this query...sel aaa.Catgy ,sum(case when bbb.Catgy = 'splat0' then 0 else 1 end )as SL from ptemp.table_1 aaa left outer join ptemp.table2 bbb on aaa.Catgy = bb...
76218 Apr 2006 @ 09:24 PDTramesh_palaConnectivityReplyTeradata ODBC Trouble in MS/AccessHi all,Even i am facing the same problem. i am not able to link teradata to access.I tried the advance options too still i have the same error.Please help....thanksramesh
76118 Apr 2006 @ 02:10 PDTperkitsureshreddyTrainingReplyPreparing for Physical Implementation Level hi iam preparing for my teradata SQL exam, can anyone post or give a link to mock exams or post any suggestion other than www.coffingdw.comthank you
76017 Apr 2006 @ 06:00 PDTKksJobsReplyTeradata/Oracle DBA Position (New York City)Hi,How a person can apply for this position?what are restrictions ?Thanks
75917 Apr 2006 @ 04:23 PDTshaik.feroz@aaa-calif.comDatabaseReplyNumber of weeks in a given month and yearIf you want to count the number of actual weeks that were in a month (i.e if the first of a month fall on wednesday this is considered a week of the month even though it did not have the whole 7 da...
75817 Apr 2006 @ 02:02 PDTBobJConnectivityTopicMS Access repeating Selects via ODBCWhen using MS Access and submitting a Select query that uses a join between a Teradata linked table and an MS Access table, the query is repeated for each row within the MS Access table. In other ...
75717 Apr 2006 @ 10:45 PDTabdysDatabaseTopicNumber of weeks in a given month and yearHi,How can I find out number of weeks in any given month and year?Please let me know.Thanks.
75617 Apr 2006 @ 10:31 PDTsamit_9999DatabaseTopicFunction Based Indexes?Can you create Function Based Indexes in Teradata , as you do in Oracle.I have collected Stats on a particular column "ABC". However when i do a substr on "ABC" and join it with a column "XYZ" in a...
75517 Apr 2006 @ 07:09 PDTven_vickTrainingReplyNR-011 CertificationHi Preeti, I just started preparing for the Exam NR0-011. May be we can do combined preparation, if you are interested. My Id is ven_vick@hotmail.com
75417 Apr 2006 @ 06:48 PDTven_vickTrainingReplyPreparation for the Teradata SQL examHi Mack or any one preparing for the Certification, I am also preparing for the Certification. Just started. Pls contact me if interested to discuss, exchange info and ideas.Thanks,ven_vick@hotma...
75317 Apr 2006 @ 12:39 PDTVinodhTrainingReplyTeradata Certification Books for SaleMay i know any soft copy for the below mentioned Books!Thanks,Vinodh
75214 Apr 2006 @ 03:47 PDTSrinivas KomaravoluTrainingTopicHow to Implement Teradata MLDMHi,Can any one help me to understand 1.How Teradata MLDM is implemented, How source OLTP data is mapped to MLDM and How is reporting done on this model, 2.How to built expertise in this Manufacturi...
75114 Apr 2006 @ 03:35 PDTSrinivas KomaravoluAnalyticsTopicMLDMHow to learn Teradata MLDM
75014 Apr 2006 @ 02:01 PDTBwillyJobsTopicTeradata/Oracle DBA Position (New York City)New York City Retail Company is looking for a DBA with 5-7 years experience in Teradata and Oracle 8/ 9i. Need to have experience in Unix scripting and Teradata utilities. Will do performance tun...
74914 Apr 2006 @ 01:22 PDTyoungDatabaseReplyquestion on TD partition, need help!thanks
74813 Apr 2006 @ 05:07 PDTrajgowdaDatabaseReplyweird issue importing from excel to TD.....Hi,Also Some time it throws same error if there is a date column.In the excel sheet you need to format the date column to yyyy-mm-dd.Thanks,Gowda C H
74713 Apr 2006 @ 05:57 PDTTDUser-781DatabaseReplyquestion on TD partition, need help!If:1. the values of your PI are unique2. the partitioning column isn't part of your PIthen you can define a USI on these columns.Then you're right!TDUser
74613 Apr 2006 @ 05:27 PDTyoungDatabaseReplyquestion on TD partition, need help!thanks for your fast reply..my question is that PI is not unique, so there existing some records with same PI values, the values are not unique, how can we define unique SI on these duplicate value...
74513 Apr 2006 @ 03:55 PDTTDUser-781DatabaseReplyquestion on TD partition, need help!Hi Young,you're right: if your Primary Index is defined as not unique (but its values ARE unique), in order to ensure uniqueness you may use a USI.But you write "PI value is not unique".... I proba...

Pages