All forum activity

#DateUserForumTypeThreadPost
1243020 Jul 2009 @ 03:50 PDTAnshDatabaseReplyRegarding Query InfoHi 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
1242920 Jul 2009 @ 03:34 PDTggEnterpriseReplywhich delimiter should i use1F is a hex value which is defined as unit separator:http://en.wikipedia.org/wiki/C0_and_C1_control_codes
1242820 Jul 2009 @ 03:17 PDTsantosh_74DatabaseReplyAdding AMPS to existing systemDoes 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...
1242720 Jul 2009 @ 01:58 PDTGopiKrishnan SDatabaseTopicSystem 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 ...
1242620 Jul 2009 @ 01:44 PDTRaja_KTEnterpriseReplyMigrating data from teradata to OracleHi,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 ...
1242520 Jul 2009 @ 12:57 PDTrob58ukDatabaseTopicDBCMNGR.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...
1242419 Jul 2009 @ 09:30 PDTsRavanSarmaToolsTopicProblem with Teradata Service ControlHi, 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...
1242319 Jul 2009 @ 07:28 PDTsRavanSarmaEnterpriseReplyMigrating data from teradata to OracleHi,Why don't you try exporting data using Teradata SQL Assistant and see whether you still have Junk characters in the exported file.
1242219 Jul 2009 @ 10:52 PDTMadMacGeneralReplySuggestion for a new Forum?Neil, I think we need a forum for the Teradata Masters. Let's get them off of that email list...
1242119 Jul 2009 @ 02:14 PDTRandom_ThoughtDatabaseReplySELECT 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...
1242017 Jul 2009 @ 08:28 PDTsureshbadamDatabaseReplyRegarding Query Infosyntax 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
1241917 Jul 2009 @ 05:28 PDTMikeCToolsReplyWhat 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...
1241817 Jul 2009 @ 05:14 PDTMikeCToolsReplyWhat 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...
1241717 Jul 2009 @ 04:57 PDTluckyToolsReplyWhat 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. ...
1241617 Jul 2009 @ 04:03 PDTJianViewpointReplyWidget developmentthanks, Lewis. Yes. we need the sparkline javascript approach, I notice commonweb has lots of great figures that we want. Could you help me to go through that. Any sample portlet like Widgtopia wi...
1241517 Jul 2009 @ 04:02 PDTDavid KorbDatabaseReplyJoined table updateThanks for the help Fred. Wow, this is more painful than I expected!
1241417 Jul 2009 @ 03:37 PDTFredDatabaseReplyJoined table updateThe 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...
1241317 Jul 2009 @ 02:32 PDTdkarrToolsReplyWhat 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...
1241217 Jul 2009 @ 02:27 PDTfgrimmerToolsReplyWhat 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...
1241117 Jul 2009 @ 02:10 PDTDavid KorbDatabaseTopicJoined table updateHi, 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...
1241017 Jul 2009 @ 02:01 PDTDavid KorbGeneralReplySuggestion for a new Forum?As a newbie to Teradata, I would add a forum for newbie questions.
1240917 Jul 2009 @ 01:50 PDTdkarrToolsTopicWhat 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...
1240817 Jul 2009 @ 01:03 PDTChandrasekaraDatabaseReplyPPI multi partition IssueFinally 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...
1240717 Jul 2009 @ 10:59 PDTluckyGeneralReplySuggestion 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...
1240617 Jul 2009 @ 10:56 PDTAnshDatabaseTopicRegarding Query InfoHi 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 ...

Pages