#DateForumTypeThreadPost
1820 Jun 2009 @ 12:33 PDTConnectivityTopicnot able to connect serveri have installed teradata software.Terada server is running correctly but not able to connect to the server from any of the client tools bteq/sqlassistant.Terdata V2R5 Version 5.0Sqlassistant 6.1.0...
1701 May 2008 @ 10:51 PDTDatabaseTopicDATABASE ADMHow Teradata Reduces DBA work comparing with other databases
1626 Nov 2007 @ 11:44 PSTDatabaseReplyHow do rollback Teradata database table?If you could have taken the backup in to any storage media we can restore it back even if you not have the permanent jounals
1526 Nov 2007 @ 08:10 PSTDatabaseReplyHow to cast the timestampsel* from entry where start_tmstp in ( case when cast(cast(extract( hour from start_tmstp)||':'||Trim(extract( Minute from start_tmstp))||':'||Trim(extract( second from start_tmstp)) as time(6)...
1422 Nov 2007 @ 09:28 PSTAnalyticsTopicAbout PE1)Can PE considered as Virtuall AMp?if so ,then , return Hashamp() includes PE also.2)How to invoke PDEConfig Utility?
1322 Nov 2007 @ 06:08 PSTConnectivityTopicError In Connecting Teradata PmonI am unable to connect the Teradata Performance Monitor.Error Is 8071:Teradata Error Form :Main Proc:Logonparameters supplied are as followsdatabasename :user name :Password:databasename I have giv...
1221 Nov 2007 @ 06:07 PSTAnalyticsReplyRegarding Space Management In TeradataYes I understood.Thanks a lot to dnoeth and Fred Pluebell
1120 Nov 2007 @ 09:05 PSTAnalyticsReplyRegarding Space Management In Teradatain the first reply you said I should have taken Sum(currentpermspace) instead of max(currentpermspace).But from the second queruy I would be know the current Perm space.There I am taking sum(Curren...
1020 Nov 2007 @ 08:32 PSTAnalyticsReplyIp address of ServerI have the DSN Name but I dont know the IP address.If i updated my Host.ini file with DNS name Rather than IP address will it work?I have updated with Dns name in Host file but it's not working.
920 Nov 2007 @ 08:26 PSTAnalyticsReplyRegarding Space Management In TeradataI have seen the DDl of Diskspace it is taking only tables which are having tableid=DBSpace.TableID = '000000000000'XBThis tableid belongs to Table name ALL.Could you explain why should we con...
819 Nov 2007 @ 08:03 PSTAnalyticsTopicIp address of ServerIs there any data Dictionary tables which maintains server name and Ip address of the server
719 Nov 2007 @ 08:00 PSTAnalyticsTopicRegarding Space Management In TeradataI am unable to Create the Table is Edwtest_Ads_Temp .but it is allowing to insert the new rows. I have checked the space .Still 879 Mb Space is available.And even no amp is full.I have used follow...
605 Sep 2007 @ 09:54 PDTDatabaseReplyJoin IndexJoin Index creates a separate Table and anychanges done to base table automatically those changes will get reflect in index table .Teradata take care of this.1.How ever When you load data through M...
509 Aug 2007 @ 05:08 PDTTrainingReplyfew QuesTeradata Maximums (V2R5.0) -------------------------------------------------------------------------------- These are Limits in TeradataSystem Limits Number of Databases/Users 4.2 Billion Messag...
408 Aug 2007 @ 01:43 PDTDatabaseReplyHow to find No of rows that a query has returned?select columnlist from B where 1
307 Aug 2007 @ 09:34 PDTConnectivityTopicODBC/CLiIs ODBC is an alternative way for CLI to connect the Teradata Server?
207 Aug 2007 @ 09:25 PDTConnectivityReplySQL 2000 to Teradata migrationOpen the designer1.then drag the sQl Stage from the database2. Give the connection properties.3.import the Table you want to load4.Drag the copy/Transform stage5.Open Properties of copy/Transform s...
107 Aug 2007 @ 05:28 PDTDatabaseReplysum of counts on 2 different tablessel count(*),a from customers,(sel count(*) from orders) as t(a)above query will give the number of rows present in both tables.Below query will give the summation of both tablessel count(*)+a from...