#DateForumTypeThreadPost
2203 Nov 2015 @ 04:15 PSTDatabaseReplyunable to cast object of type 'system.dbnull' to type 'system.string'Looks like some defect in casting the Nulls to String for the next row after 'Maximum Number of answer rows to Display' setting in SQL Setting Options.
2116 Aug 2012 @ 09:55 PDTDatabaseTopicQuery Execution Error Teradata SQL Assistant 13.10   Hi I have Teradata SQL Assistant 13.10 installed on my new OS windows 7 enterprise.  It was working fine for the last two weeks. But getting the below error when I am run...
2014 Jun 2011 @ 06:47 PDTGeneralReplyBTEQ Export to override existing fileThanks Jimm
1921 May 2011 @ 04:41 PDTGeneralTopicBTEQ Export to override existing fileHi We are creating data files using BTEQ export in Unix environment. We have to create a fresh data file each week. I want to override previous export file when I run BTEQ export. Please h...
1814 Dec 2010 @ 08:14 PSTGeneralReplyconvert month value 201004 into Apr-2010Carlos Thank you so much...you are a Guru
1714 Dec 2010 @ 06:11 PSTGeneralTopicconvert month value 201004 into Apr-2010Hi I have to perform a join on month. In one table the value stored as 201004 (varchar (10)) and another table value stored as Apr-10 (varchar (20)) I am trying to convert either of the...
1616 Aug 2010 @ 02:44 PDTGeneralReplyHow to start teradata service in suse linux vmware image (teradata express 13.0)you can use the terminal to use bteq. type bteq in terminal and press enter. then you can see the bteq version and all information as you see in windows.. then....type the following comman...
1510 Aug 2010 @ 02:47 PDTGeneralReplyHow to start teradata service in suse linux vmware image (teradata express 13.0)first you need to start Teradata Service logon as root and to start teradata service type the following command in linux terminal: /etc/init.d/tpa start.
1405 Jun 2010 @ 08:59 PDTDatabaseTopicinsert records time incrementalHi Gurus I have data in table with timestamps like follows CD ACCTIME AMOUNT AK,2006/10/10 08:03:00,40.20 DC,2006/10/10 08:14:00,40.24 DE,2006/10/10 08:21:00,40.28 NJ,2006/10/1...
1313 Apr 2010 @ 09:14 PDTGeneralReply2683 Numeric Overflow occurred during computation-MultiLoadsuma.. its not exceeding 999999.99 the data value is less than this... madrockster... there is no aggregation/caliculation and I am trying to update 1 column and 21 rows in 12 column 21 ro...
1207 Apr 2010 @ 02:32 PDTGeneralTopic2683 Numeric Overflow occurred during computation-MultiLoadHi Gurus Iam trying to update a small table using multiload... I got an error 2683 numeric overflow occurred during computation. the column data type is decimal (8,2) and the data in the file ...
1107 Apr 2010 @ 09:26 PDTGeneralReplyFDL4822 DEFINE statement rejected.Hi Vador I have corrected the script ...now I got succeeded Thanks
1002 Apr 2010 @ 03:58 PDTGeneralReplyBTEQ Import Data file errorHI Jim Here is my insert statement USING EmpNo (Smallint), Name (Varchar(12)), DeptNo (Smallint), JobTitle (Varchar(12)), Salary (Decimal(8,2)), YrsExp (Byteint), DOB (Date), Sex...
901 Apr 2010 @ 10:40 PDTGeneralTopicBTEQ Import Data file errorHi Gurus Iam trying to import datafile into a table using BTEQ import...getting the following error any help appreciated... Thanks *** Starting Row 2 at Wed Mar 24 15:40:18 2010 *** F...
801 Apr 2010 @ 10:36 PDTGeneralTopicFDL4822 DEFINE statement rejected.Hi Iam trying to load a small sample data using fast load..and Iam getting the following error.. Can any one help me please.. FDL4822 DEFINE statement rejected. and log file is as follows:...
715 Mar 2010 @ 12:47 PDTGeneralTopicMultiLoad Error: UTY0805 RDBMS failure, 2644: No more room in database personnel.Hi Iam new to Teradata VM Ware 40gb edition. Iam trying to update a small table which is having 21 records and getting an error; UTY0805 RDBMS failure, 2644: No more room in database personn...
615 Mar 2010 @ 12:38 PDTToolsReplyCode = 2644 No more room in databaseHi even Im getting the following error in MultiLoad VM Ware edition...I am just trying to update a small table which is having 21 records UTY0805 RDBMS failure, 2644: No more room in database...
520 Nov 2009 @ 11:16 PSTUDAReplyTeradata Role in a Retail client projectViss...Thanks for your suggestions...now Iam practicing on windows envt...how can I practice on Mainframe and Unix envts....please suggest.thanks
419 Nov 2009 @ 08:59 PSTUDAReplyBTEQ Signon problem CLI: 224i think in 12.0 the data source is localtd try to login as follows.logon localtd/pervezpassword:pervezit will work out
317 Nov 2009 @ 05:27 PSTUDATopicTeradata Role in a Retail client projectHello AllIam new to Teradata...can any one suggest a material / explain me the basic role of a Teradata developer in a real time environment thanksmeta
216 Nov 2009 @ 01:16 PSTConnectivityReplyhow to install teradata express edition on windows 7Hi alleven Iam looking to install TD Demo version on Windows 7...please helpthanks
116 Nov 2009 @ 01:13 PSTAnalyticsTopicRequirements GatheringHiIam new to Teradata..can any one tell me the process of Requirements Gathering in Teradata warehousingthanks