#DateForumTypeThreadPost
2411 Feb 2011 @ 10:03 PSTToolsTopicMultiload on Teradata 12 desktop edition hung.Hello all, I am facing a strange problem where in my mload script goes into hung state while loading the data. The solution that works for me is to restart the Teradata while MLoad is in hung st...
2321 Dec 2010 @ 11:55 PSTToolsReplyDate Formating in Multiload ScriptDieter, date is already in the dd-mm-yyyy format. I have tried the syntax you mentioned as .DML Label CorpAction_Ins; INSERT INTO TestDB.actDate ( Script, RECORD_DT ) VALUES(:Script, :RECORD...
2221 Dec 2010 @ 02:43 PSTToolsTopicDate Formating in Multiload ScriptI am trying to upload a date column from as coma separated file (CSV). Date in CSV file is in dd-mm-yyyy format however Teradata expects it to be in mm/dd/yyyy format. How do I change the format ?...
2102 Nov 2010 @ 11:31 PDTToolsReplyHow-to Skip duplicatesTry using fast load. It ignores duplicate rows.
2002 Nov 2010 @ 11:23 PDTToolsReplymload upload of csv file with Comma ',' and ""First load data with '' and "" into db then strip off the single quotes and double quotes.
1907 Apr 2009 @ 06:11 PDTDatabaseTopicNot able to connect using BTEQHello,I have installed Teradata 12.0 demo on Windows Vista pc. Installation went smooth and i am able to connect to Teradata using SQL Assistance. However it give "entry not found in host file" err...
1821 Jun 2007 @ 02:44 PDTDatabaseTopicChange PasswordHi,how can I change the password of a Teradata login ?Regards
1703 Feb 2007 @ 02:44 PSTDatabaseTopicReducing colum lengthHi,I want to reduced the length of a column from varchar (60) to varchar (50), can this be done ?What is the correct syntax for thatRegards
1615 Jan 2007 @ 07:42 PSTDatabaseTopicLock InformationHi,How can I get the information about the Locks acquired buy other users on a table or dabatabse ?
1525 Jul 2006 @ 12:19 PDTDatabaseTopicTDPID Vs AccountIDHi,What is the difference between TDPID and Account ID parameters of LOGON command that we give while logging to Teradata using BTEQ ?Regards
1407 Jun 2006 @ 02:48 PDTConnectivityTopicExtended Stored Procedure to send mailHi,I am in the process of developing an extended stored prodedure that will sent mail. The Teradata system on which this prodedure will be used is a 6 node system. It is necessary to have SMTP conf...
1307 Jun 2006 @ 02:26 PDTDatabaseTopicFinding Foreign Key for Primary Key ColumnHi,Is there is a way to find foreign key columns that references to a primary key ?i.e I have table PrimaryTable which has Col1 as primary key. I want to find out the tables having columns that ha...
1228 Mar 2006 @ 06:49 PSTDatabaseReply10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkHi Vinay, How the use of DNS server for resolving the IP address can solve the problem ?I am facing the similar kind of problem where my ASP.Net application uses which OLE Db provider for Teradata...
1128 Mar 2006 @ 06:45 PSTConnectivityTopicTeradata Server not Found errorHi,My ASP.Net application uses OLE Db provider for Teradata to connect to Teradata Server on unix box. During weekdays application works fine however during weekends it starts giving the error whic...
1028 Feb 2006 @ 12:50 PSTDatabaseTopicScheduing a stored procedureHi,Is there is a way to schedule the execution of a Stored Prodecure or Macro in Teradata ?My basic requirement is to execute a Stored Procedure / Macro daily.Akhil-
908 Feb 2006 @ 02:44 PSTDatabaseTopicHow to get Teradata Version ?Hi,How can i know which version of teradata is installed on my system ?Regards
807 Feb 2006 @ 06:38 PSTDatabaseTopicProblem executing recursive query from Sql AssistantHiWhen i execute the below mentionet sql from BTEQ it works fine however when it is executed from Sql Assistant it gives the error "3706: Syntax error: Expected something between the begenning of t...
706 Feb 2006 @ 08:27 PSTDatabaseReplyINSERT EXPLAIN not workingHi Kishaninstead of trying INSERT EXPLAIN INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.SERVICING_ENTITYPlease try this EXPLAIN INSERT INTO QCD AS QUERY_0001 SELECT SVC_ENTY_ID FROM DB_TX.S...
623 Jan 2006 @ 02:25 PSTDatabaseTopicRemoving Column FormatHow can the Format defined for a column be removed ?
510 Jan 2006 @ 02:01 PSTDatabaseTopicConversion of Primary to Secondary indexHi, Is there a way to convert Primary index to Secondary index ?Thanks and Regards
409 Jan 2006 @ 11:26 PSTDatabaseReplyString ReplacementHi DanielThanks for this stored procedure. But is there is a way that I can use this in Select statement ?Regards
304 Jan 2006 @ 04:49 PSTDatabaseReplyString ReplacementHi Vinay, It works fine. thanks.But what do you mean by crude form ?
202 Jan 2006 @ 05:16 PSTDatabaseTopicString ReplacementHi,Is there is a way to replace a particular in a column with another character ?Support a Column values likeYahoo and HotMailHotMail and YahooYahoo and GMailGMail and HotMailI would like to replac...
117 Jul 2005 @ 11:18 PDTDatabaseTopicUnable 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...