|12430||20 Jul 2009 @ 03:50 PDT||Ansh||Database||Reply||Regarding Query Info||Hi Friends,Could you also confirm,can we use IN and NOT IN functions in Case statements also like below :When (COLUMN_1 = 'X' And COLUMN_2 in('20','21' )) Thanks for your responses |
|12429||20 Jul 2009 @ 03:34 PDT||gg||Enterprise||Reply||which delimiter should i use||1F is a hex value which is defined as unit separator:http://en.wikipedia.org/wiki/C0_and_C1_control_codes |
|12428||20 Jul 2009 @ 03:17 PDT||santosh_74||Database||Reply||Adding AMPS to existing system||Does all the data that exists in the warehouse undergoes redistrubution every time you are adding resources to your system ?what happens to existing appliations/programs which are accessing the dat... |
|12427||20 Jul 2009 @ 01:58 PDT||GopiKrishnan S||Database||Topic||System Error 126 (Teradata)||Hi All,I am getting the below mentioned error while connecting to Teradata server from Business Objects.Error Message: "A database error occured. The database error text is: Specified driver could ... |
|12426||20 Jul 2009 @ 01:44 PDT||Raja_KT||Enterprise||Reply||Migrating data from teradata to Oracle||Hi,I m thinking this way:.LOGTABLE fexp_logtab;.LOGON 127.0.0.1/tduser,tduser;DATABASE dbc;.BEGIN EXPORT SESSIONS 20;.EXPORT OUTFILE 'your path' FORMAT TEXT;SELECT (CASE WHEN location_key IS NULL ... |
|12425||20 Jul 2009 @ 12:57 PDT||rob58uk||Database||Topic||DBCMNGR.UserCounts ||In the Teradata databse V2R6.2 'Performance Management' manual
Page 24 of 430 "Establishing a performance Management Database"
Refrences a table called DBCMNGR.UserCounts
I cannot find any other... |
|12424||19 Jul 2009 @ 09:30 PDT||sRavanSarma||Tools||Topic||Problem with Teradata Service Control||Hi, I was trying to start Teradata using Teradata Service control but its saying that "Bynet Installed, but not running. Reboot to start".I tried to reboot my system and even after that I am gettin... |
|12423||19 Jul 2009 @ 07:28 PDT||sRavanSarma||Enterprise||Reply||Migrating data from teradata to Oracle||Hi,Why don't you try exporting data using Teradata SQL Assistant and see whether you still have Junk characters in the exported file. |
|12422||19 Jul 2009 @ 10:52 PDT||MadMac||General||Reply||Suggestion for a new Forum?||Neil, I think we need a forum for the Teradata Masters. Let's get them off of that email list... |
|12421||19 Jul 2009 @ 02:14 PDT||Random_Thought||Database||Reply||SELECT TOP N - odd behaviour (v2r6)||@rluebke - Could you expand on this a little? what clue in the Explain do you see that leads you to think it needs more up to date Stats? I saw that it read 209 million rows, so it must have stat... |
|12420||17 Jul 2009 @ 08:28 PDT||sureshbadam||Database||Reply||Regarding Query Info||syntax look correct.Nested case syntax is below (same as typical if ...else)case when condition1 then case when condition 2 then result2 else result3 endelse result4end |
|12419||17 Jul 2009 @ 05:28 PDT||MikeC||Tools||Reply||What tool (SQL Assistant?) do I use to browse a Teradata database?||Check out http://developer.teradata.com/tools/articles/teradata-express-edition-12-0 to see how to get and Install Teradata Express Edition.
Also Check out http://developer.teradata.com/applicat... |
|12418||17 Jul 2009 @ 05:14 PDT||MikeC||Tools||Reply||What tool (SQL Assistant?) do I use to browse a Teradata database?||Teradata Express Edition 12.0 — Teradata Software for Evaluation and Development (available at http://www.teradata.com/t/teradata-12.0/) includes Teradata Tools and Utilities (TTU) 12.0 - the ful... |
|12417||17 Jul 2009 @ 04:57 PDT||lucky||Tools||Reply||What tool (SQL Assistant?) do I use to browse a Teradata database?||SQLAssistant is part of the Teradata Tools and Utilities (TTU) pack. The installer for it can be found on the TTU CD which you (or your DBA) should have received if/when you purchased Teradata.
|12415||17 Jul 2009 @ 04:02 PDT||David Korb||Database||Reply||Joined table update||Thanks for the help Fred. Wow, this is more painful than I expected! |
|12414||17 Jul 2009 @ 03:37 PDT||Fred||Database||Reply||Joined table update||The main thing is you're not allowed to qualify the column name on the left-hand side of the SET clause at all. Omitting the alias on the target table, syntax would be:
update login.table_aggreg... |
|12413||17 Jul 2009 @ 02:32 PDT||dkarr||Tools||Reply||What tool (SQL Assistant?) do I use to browse a Teradata database?||Not really. I'm using Eclipse 3.5, and it fails to install in that environment. As it's likely not ready for 3.5 yet, I figured I'd need to use some other tool, like this "SQL Assistant" that I've... |
|12412||17 Jul 2009 @ 02:27 PDT||fgrimmer||Tools||Reply||What tool (SQL Assistant?) do I use to browse a Teradata database?||You can use the Teradata Plug-in for Eclipse, currently supported on Eclipse 3.4.1.
There is an article that will help you get started at: http://devxweb.td.teradata.com/tools/articles/getting-st... |
|12411||17 Jul 2009 @ 02:10 PDT||David Korb||Database||Topic||Joined table update||Hi, I've just arrived to the Teradata world from SQL Server and learning the new syntax. How do you update a table using a join?
The first approach I used was what I have been doing: create alia... |
|12410||17 Jul 2009 @ 02:01 PDT||David Korb||General||Reply||Suggestion for a new Forum?||As a newbie to Teradata, I would add a forum for newbie questions. |
|12409||17 Jul 2009 @ 01:50 PDT||dkarr||Tools||Topic||What tool (SQL Assistant?) do I use to browse a Teradata database?||I'm not going to be using Teradata much, but I may need to browse a particular Teradata database. What tool do I need to install (MS Windows XP) so I can do that? I've heard of "SQL Assistant", b... |
|12408||17 Jul 2009 @ 01:03 PDT||Chandrasekara||Database||Reply||PPI multi partition Issue||Finally I got solution for this. See below.ALTER TABLE AR_ADJ MODIFY PRIMARY INDEX AR_ADJ_NP PARTITION BY RANGE_N(Per_Ym BETWEEN 200501 AND 200512 EACH 1,200601 AND 200612 EACH 1 ,200701 AND 200... |
|12407||17 Jul 2009 @ 10:59 PDT||lucky||General||Reply||Suggestion for a new Forum?||@Random_Thought That's actually a good idea. Since we only launched the forums this week, I think I want to wait a couple of weeks and collect any other suggestions people have, before deciding wh... |
|12406||17 Jul 2009 @ 10:56 PDT||Ansh||Database||Topic||Regarding Query Info||Hi All,Can I use this below condition in the case statement which have two columns from the same table like :Case When ANS.Column_mig <> ANS.Column_mig2 OR Case When ANS.Column_mig ... |