All forum activity

#DateUserForumTypeThreadPost
4417 Nov 2005 @ 12:03 PSTnitinrpAnalyticsTopicEXcel to TeradataHi ,I have an Excel file with 1000 records ,i want to get these 1000 records to be loaded in teradata.Does any one know how to get this done and which utility will help me to get the excel file to ...
4301 Nov 2005 @ 09:43 PSTSandiUDATopicData retrieval queryHi all,I want to retrieve last 3 months data from a table,in which datas are loading daily. I have a query but it is retrieving last 3months data + data loaded till current day.But I need only last...
4228 Oct 2005 @ 01:03 PDTUday@igateToolsTopicNeed help abt Teradata start up !!!!Hi,I am novice to Teradata.We have installed Teradata Evaluation CD on a stand-alone system.But its NOT connected to Teradata database Server.1.Is it possible to run BTEQ and other utilities ?2.Who...
4111 Oct 2005 @ 12:56 PDTRicardoToolsTopicTpump PerformanceHiI have a teradata Environment with 48 Amps , and I have a a table (sales_history) with 235.000.000 rows , I´m loading it with a Multiload utility , I want to change it for a tpump, but I, don´...
4010 Oct 2005 @ 12:48 PDTGRH65DatabaseTopicTeradata Error 2621 - Bad character in format or data of {table nm} column 7Can anyone explain to me what the actual definition of this error is? I have taken a look at the data and nothing looks out of the ordinary. I am creating a couple of volatile tables and updating o...
3910 Oct 2005 @ 09:45 PDTpmikToolsTopicRemove a table lock if fastload failsHello, I need help with fastload. I want to remove lock on a table which was fastloaded and fastload fails (record were wrong). If the fastload fails, than the table is locked and you can't work wi...
3828 Sep 2005 @ 08:53 PDTMuruganTrainingTopicdata contains bad characteri am having this type of problem any one can help me? [NCR][ODBC Teradata][Teradata RDBMS] The format or data contains a bad character.
3725 Sep 2005 @ 12:27 PDTdoryenToolsTopicDemoTDAT logon/passwordHi,I have been working with SQLAssistant.I would like to work with BTEQ.In my host entry the following is typed:127.0.0.1 localhost DemoTDATI tried to logon through the following command.logon Demo...
3614 Sep 2005 @ 04:56 PDTApukadUDATopicGrouping setsHello All,I have a problem, because i would like to order the query result with totals. But the ordered fields format are decimal(8,0)-month_id and date ('YYYY-MM-DD'). I tried to correct with coal...
3512 Sep 2005 @ 03:05 PDTWinsTrainingTopicIncemental BackupHi All, Please let me know how Incremental Backup is done in Teradata. What is needed for incremental Backup and what is cluster backup?Any help is much appreciated.Thanks,Naveen.
3421 Aug 2005 @ 03:54 PDTpreetiTrainingTopicNR-011 CertificationHi,I'm planning to give the teradata NR-011 certification.ie teradata basics exam.I have given 1 test on teradata.com and there is one on coffingdw.com.Is there any other -mock test site or dumps w...
3316 Aug 2005 @ 04:10 PDTJSwanToolsTopicERROR ~ [Teradata DBMS] : Response limit exceeded.I MOVED THIS TO A MORE APPROPRIATE FORUMOur Java app is throwing this error :com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata DBMS] : Response limit exceeded.Anyone ever had this error b...
3212 Aug 2005 @ 07:43 PDTTD_ArchDatabaseTopicIdentity Column Not Coming in a sequence. Need Suggestion.I have to generata a Sequence of numbers as the primary index.But , after the insertions of some sample data, i find that it is not completely in sequence. I get numbers from 1 thru 10, then number...
3117 Jul 2005 @ 11:18 PDTakhil.bansal@gmail.comDatabaseTopicUnable to login througj BTEQHI, I have recently installed Teradata Demo CD on my Windows XP (SP2). Teradata installed properly on my system and I am able to connect to Database through SQL assistant. However I am facing probl...
3015 Jul 2005 @ 09:02 PDTWOCSIConnectivityTopicTerada ADODB performance issue.I am a loadtester test on of my groups and notice that the create Object method is not scaling. I am lucky to get 10 users running and response times are taking over a minute to create. Any ideas w...
2930 Jun 2005 @ 08:26 PDThotspearDatabaseTopicHelp on SQLcreate table aa(a int, b char);insert into czhu.aavalues(1, 'a');insert into czhu.aavalues(1, 'b');insert into czhu.aavalues(2, 'c');insert into czhu.aavalues(2, 'd');insert into czhu.aavalues(2, '...
2828 May 2005 @ 07:32 PDTbhaskaranTrainingTopicTeradata Certification Level II need to take up to Teradata Certification Level I. Can any one tell me how to prepare for that and what are the topics that I need to focus on.Regards,Bhaskar.S
2720 Apr 2005 @ 05:27 PDTsathyaAnalyticsTopicidentity columnsneed to generate a sequence number for every row inserted.Tried with identity columns but to no avail.Table A(has only one column)col1 1 2 3Table B(has two columns col1 and col2)col1 identity co...
2612 Apr 2005 @ 03:42 PDTc9jadToolsTopicPivot a table with SQLDoes anyone have a good way to pivot a table when there is a variable amount of columns? I know that it can be done with a CASE statement, but that is tedious.
2506 Apr 2005 @ 02:47 PDTsaketTrainingTopicnew to teradataHi All,This is saket. I am new to Teradata.I have been assigned project recently and finding it hard to grasp things.I don't have prior working experience.I request you all to tell me the right app...
2418 Mar 2005 @ 08:01 PSTvikasUDATopicProblem in MloadAfter the application phase it drops all the error tables but when it tries to drop the log table during log off, following error occurs. **** 22:41:42 UTY0683 Invalid Data Prefix Block.And it give...
2308 Mar 2005 @ 04:47 PSTTifosiAnalyticsTopic6706 ErrorHi all,I am MLOADING some data in a table nad getting 6706 error.Not able to figure out where the problem is.One more strange behavior is that the data is loading fine in the production environment...
2202 Mar 2005 @ 04:05 PSTKarl WDatabaseTopicWarehouse 8.0 Demo ?Hi,Does anyone know if/when a demo version of Warehouse 8.0 will be released ?Thanks,Karl
2115 Feb 2005 @ 11:39 PSTRaj RadhakrishnanThird Party SoftwareTopicTeradata and Ascential Data StageHi,Following is the background of the problem and my questions:Problem Background:I have a SELECT query that takes 16sec to return the answer set using Queryman or BTEQ. The optimizer chooses a pla...
2010 Feb 2005 @ 12:37 PSTninnuDatabaseTopic*** Failure 3812 The positional assignment list has too few values.i got the below error:*** Failure 3812 The positional assignment list has too few values.what does that mean?

Pages