#DateForumTypeThreadPost
1028 May 2016 @ 07:11 PDTDatabaseReplyLoading Data from TD DB to Any Exernal fileWhat exactly you mean with external file? If you are referring to data file at file system, you can leverage TPT export or fast export utilities.   --Gyan
928 May 2016 @ 06:14 PDTToolsReplyNeed of Collect StatisticsHi Sanjay, Prior to V14.0 DBC.Indexes (for multi-column indexes only) DBC.TVFields (for all columns and single column indexes)   After V14.0 DBC.StatsTbl   --...
807 Aug 2014 @ 08:19 PDTToolsReplyTeradata SQL Assistant 13.11 - Where can I download?You can download newer version (15.0) at below link. Unzip and run the base file and chosse SQL assistant.   http://downloads.teradata.com/download/tools/teradata-tools-and-utilities-windows...
707 Aug 2014 @ 08:06 PDTGeneralReplycould anyone please tell me can we alter a join index tableHi Purushotham, Join index support UPI. Please tell me if you are getting any error while defining UPI on join index.
606 Aug 2014 @ 02:01 PDTDatabaseReplyTeradata Express for WIN 32 BITHi Hema, Go to below URL and scroll down to other downloads. You will find several version of 13.10. http://downloads.teradata.com/download/database/teradata-express/vmware  
518 Jun 2014 @ 05:35 PDTDatabaseReplyMultiplication of DecimalsHi Khurram, I have tried below two scenarios on (v12 and V14.10 both). CREATE VOLATILE TABLE X (col VARCHAR(255)) ON COMMIT PRESERVE ROWS; CREATE VOLATILE TABLE Test_Decimal (col DECIMAL (16...
417 Jun 2014 @ 05:33 PDTDatabaseTopicMultiplication of DecimalsI am multiplying too decimals. I am running below query in two different servers. In one system DBS Parameter - MaxDecimal is set as 15 whereas another has DBS Parameter - MaxDecimal as 3...
311 Apr 2012 @ 05:01 PDTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! Hi Raj, You will see an shortcut on your desktop "Teradata Service Control". Launch that and click the option "Start the Teradata". Once Teradata is running, go to OD...
211 Apr 2012 @ 04:54 PDTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums!   Hi Kisansenapati,   Make a BTEQ script and call that from Unix and Your BTEQ file will look like below-   .logon <Host id>/<User id>,<password...
111 Apr 2012 @ 04:43 PDTGeneralReplytable does not exist Hi, I have faced similar issue some time back. We had to rename the database so we created new database and copied all objects and permissions. After compiling all the procedures in new data...