#DateForumTypeThreadPost
2007 Jul 2014 @ 03:09 PDTToolsTopic3706 expecting something between beginning of the request and SELECTSELECT * FROM CUST.MEMBER This simple SQL runs just fine if I type it on SQL Assistant. But if I copy paste this from notepad SQL assistant throws this 3706 error. There are times, to debug a code...
1931 May 2014 @ 08:36 PDTTeradata StudioReplyStudio 15 install on TD supplied DellI tried installing TD Studio Express 15, I have 14 with me. C:\Users\>java -version java version "1.7.0_60" Java(TM) SE Runtime Environment (build 1.7.0_60-b19) Java HotSpot(TM)...
1807 Feb 2014 @ 11:28 PSTDatabaseReplyCROSS JOIN in for Rule CheckNever mind! I solved it. Thanks Guys! SELECT STUDENT_ID, SUM(MARK) OVER (PARTITION BY OUTPUT.STUDENT_ID), CASE WHEN SUM(MARK) OVER (PARTITION BY OUTPUT.STUDENT_ID) BETWEEN STRT_VAL AND END_VAL...
1707 Feb 2014 @ 11:09 PSTDatabaseTopicCROSS JOIN in for Rule CheckHi Gurus, I have a rule table which look slike Mark_SL#      STRT_VAL       END_VAL        DESCR 1&...
1603 May 2013 @ 09:24 PDTDatabaseReplyindexes & create table performanceCreate table with data, as far as I understand is 3 part operation. 1) Create table 2) Select data from table B 3) insert data into table C I dont think insert has a major impact on t...
1510 Mar 2013 @ 10:10 PDTDatabaseReplyIs it good to creating SET table with UPI or NUPI and why..?SET table with UPI is always better because it enforces the uniquencess of the data in turn it ensures that data is distributed across AMPS evenly. A evenly distributed data improves the performanc...
1415 Jun 2012 @ 10:57 PDTDatabaseReplyrewrite a sql query I could not understand the purpose of this query? Can you please explain what is the data that you are trying retrieve?
1315 Jun 2012 @ 10:38 PDTDatabaseTopicTeradata-14 Architecture Hi Gurus,   Can you pleast give me link to architeture diagram of MPP with all the components?   Thanks!
1202 May 2012 @ 04:17 PDTDatabaseTopicKeyword USING while joining the tables Hi All, I know in Oracle, we can join 2 tables using "USING" Keyword for example SELECT STUDENT_NAME, DEPARTMENT_NAME FROM STUDENT JOIN DEPARTMENT USING (DEPARTMENT_ID) ...
1125 Apr 2012 @ 04:11 PDTAnalyticsReplyDate gap analysis Hi,   Please look at this post by dieter back in 2010,   http://forums.teradata.com/forum/database/how-to-find-the-continious-records-based-on-key-column#comment-12490 ...
1025 Apr 2012 @ 11:05 PDTDatabaseReplyLeft outer join help Yes.. Thank You... I appreciate it..
925 Apr 2012 @ 10:40 PDTDatabaseReplyLeft outer join help Hi Dieter, I ran this query using a test table created and try to see whether any inner joins are present in explain plan or not, but I could not find them. Possibly I am reading the ex...
825 Apr 2012 @ 06:53 PDTAnalyticsReplyinsert Data I guess it is a trade-off based on the number of partions that you have on the table, the volume of data that you have, the number of indexes and the type of indexes. If the volume of the data i...
722 Dec 2009 @ 05:25 PSTUDATopicDifference between NOT and NOT INCan you please help me with the difference between below queries.Sel * from TABLEwhere NOT (NAME= 'L'AND ID= '123')Sel * from TABLEwhere (NAME<> 'L'AND ID<> '123')I assumed that both sh...
606 Aug 2009 @ 09:07 PDTDatabaseTopicUpdate all rows except one row in a tableI need to update all rows except one row in a table. ExampleA B C 1 2 3 UA B C 1 2 4 UX Y Z 6 7 8 UT U I P U 1 UA K T 1 2 4 UX Y Z J 7 8 UT R I P U 1 UThis data needs to be c...
526 Jun 2009 @ 06:28 PDTToolsReplyIssues with EXPORT OUTPUT DATE FIELD is not coming correctlyI would not be able to cast it as the SQL is generated dynamically. I thought to cast it to char with length based on column length from the table, but since I see that it is 4, that is also had to...
426 Jun 2009 @ 05:40 PDTToolsTopicIssues with EXPORT OUTPUT DATE FIELD is not coming correctlyI have some issues with TD Export command. The SQL I use in export command is SELECT BUSINESS_UNIT ,' | ',EFFDT ,' | ',EFF_STATUS FROM ABC The output of this is spooled to a file called ABC.txt. $...
325 Jun 2009 @ 05:16 PDTToolsTopicExport output file formattingHi Guys,I am using an export command in a BTEQ script. The output file needs to be formatted to get the a comma, pipe(|) or ~ delimited file. Can you guys please help me in this regard? The SQL Sta...
217 Jun 2009 @ 11:28 PDTDatabaseReplyHow to find the row difference in TeradataHey Jim,Thanks My friend, after little tweaking it works perfectly. You made my day. I appreciate your help!!!!
117 Jun 2009 @ 11:50 PDTDatabaseTopicHow to find the row difference in TeradataHi All,I have come across a typical problem. Basically to aggregate the broken insurance details based on their continuity. Let me tell you the details with an exampleInsurance# St...