#DateForumTypeThreadPost
1023 Jul 2008 @ 06:16 PDTDatabaseReplyError-Missing/Invalid SQL statement'E(3706):Syntax errorFirst try to identify from which block the error is happening.Then check the syntax.Thanks.
903 Jul 2008 @ 02:18 PDTUDAReplyDate formatThanks Fred...Seems that's the only option available...
803 Jul 2008 @ 02:17 PDTUDAReplyDate formatThanks Fred...Seems that's the only option available...
719 Jun 2008 @ 01:06 PDTUDATopicDate format[font=Tahoma]Hi, I am getting a file which has a date value. But if the months or days are less than 10, then the date format will be M/D/YYYY (1/1/2008). If it is greater than 10, then the fo...
626 May 2008 @ 10:20 PDTToolsReplySQL Assistant behaving weirdPlease check the answer in the following linkhttp://www.teradata.com/teradataforum/Topic11590-9-1.aspx
526 May 2008 @ 02:22 PDTDatabaseReplySQL Assistant behaving weirdPlease uncheck the option "use localized date display format" in Tools-->Options-->General tab
422 May 2008 @ 03:05 PDTUDAReplyBT/ETSome more information on multistatements......ie,BT;stmt1;stmt2;ET;In Teradata these are referred as multistatement inserts.It seems multistatement insert is a feature in teradata that allows for o...
320 May 2008 @ 01:40 PDTUDAReplyTransactionThanks Fred.This is really good information. So that means in option 1, we need to check the errorcode immediately after the DELETE statement...
219 May 2008 @ 07:24 PDTUDATopicTransactionHi, We came across a specific scenario in Teradata transaction processing.As you might know we can use BT and ET in bteq section to control the rollback and commit process for multiple queries.We t...
101 Aug 2007 @ 04:29 PDTUDAReplyTeraData vs OracleTeradata is a MPP System which really can process the complex queries very fastly..Another advantage is the uniform distribution of data through the Unique primary indexes with out any overhead. Re...