#DateForumTypeThreadPost
5331 Jul 2016 @ 12:35 PDTDatabaseReplyAggregate details into summary - case statementUpdated detailed table with missing column: ID          AWARD_TYPE_CD          GSM     LL      Loyalty Points &nb...
5230 Jul 2016 @ 01:15 PDTDatabaseTopicAggregate details into summary - case statement Dears, We need to summarize the below detail data as expected; but somewhere we are missing something and not getting the proper aggregate. Pls help.   Detailed data:  ...
5129 May 2016 @ 03:03 PDTDatabaseTopicCREATE TABLE Failed [3737] - NAME REQUIRES MORE THAN 30 bytes IN LATIN INTERNAL FORMWhen I run the create statement got this error. I know that table name or column name should be less than 30 characters. But the question is why its "more than 30 bytes in LATIN INTERNAL FORM...
5026 May 2016 @ 01:50 PDTDatabaseReplyLeft join and filter NULL doesnt work!Your query should not return NULL record: select * from table1 a left join table2 b on a.colA = b.colA where b.colA is not null  
4916 May 2016 @ 10:54 PDTDatabaseReplyConversion of Integer to Date Format in TeradataChange it to the Teradata internal date format: create table temp1 ( Time_1 integer ); insert INTO temp1('201604'); insert INTO temp1('201605'); insert INTO temp1('20...
4804 Apr 2016 @ 04:03 PDTDatabaseReplyUV tableThanks Dieter!! UPDATE table_name SET emp_name=:emp_name ,salary=:salary WHERE empid=:empid;  
4704 Apr 2016 @ 04:01 PDTDatabaseReplyHow to identify the exact line number or SQL code which is causing bad character issue - Error Code 2620 Got it Dieter! Thanks for the quick help!!     25) We do an all-AMPs JOIN step from Spool 34 (Last Use) by way of an      all-rows scan, which is joined...
4604 Apr 2016 @ 03:44 PDTDatabaseTopicHow to identify the exact line number or SQL code which is causing bad character issue - Error Code 2620Hi All, Is there any way to identify the exact line number or SQL code which is throwing "SELECT Failed. 2620:  The format or data contains a bad character." issue? Most of th...
4504 Apr 2016 @ 03:25 PDTDatabaseReplyUV tableApply trim and try to select particular record. If you're select is successful then you can apply the same to update also sel * from table_name where empid = trim('1234');  
4404 Apr 2016 @ 02:28 PDTDatabaseReplyUV tablePlease share some samples and logs.
4330 Mar 2016 @ 12:55 PDTDatabaseReplyTo Search a String in a different Column String , in which Search String is just part of - SQL QuestionHi Swathi, As you said these two columns are from different tables and you want to search the matching string in table2.column as per table1.column; I hope the below SQL helps! create volatile ...
4229 Mar 2016 @ 01:00 PDTDatabaseReplyEncountered an error using SUM Over Partition byHi Narasimha, But query fails still since columns which are used in partition by clause are not aggregated.
4129 Mar 2016 @ 12:48 PDTDatabaseReplyCreate list of dates (1)    Is there a better query to use to generate this list Sakthi: To generate next consecutive 31 days your query is better enough (2)    Is there a way to format ...
4024 Mar 2016 @ 06:21 PDTDatabaseReplyDate prompt in Pass Through QueryHi Ray, Default date format is yyyy-mm-dd; Please keep your file data in this format and try once.
3923 Mar 2016 @ 10:05 PDTDatabaseReplyDate prompt in Pass Through QueryHi Ray, Make sure that the format of Date column in Target is same as the one in file you are using for Import. You can add a FORMAT in the SELECT query instead of changing the format in your inpu...
3823 Mar 2016 @ 04:30 PDTDatabaseReplyStore Negative decimal value into teradata datatypeThanks Dieter!! As Dieter said you can use to_number() as shown below: insert INTO b select CAST(coalesce(to_number(col1),0.0) as decimal(5,2)) from a;  
3723 Mar 2016 @ 03:44 PDTDatabaseReplyStore Negative decimal value into teradata datatypeHi Shabeena, I don't see any issue on that -  create volatile table a ( col1 varchar(20) ) on commit preserve rows; insert INTO a values ('26.66'); insert INTO a values ...
3622 Mar 2016 @ 04:25 PDTDatabaseReplyTransposing Rows to ColumnsQuery given by Chinmay is working fine. But not sure about the performance if data size more.
3522 Mar 2016 @ 02:19 PDTDatabaseReplyTransposing Rows to ColumnsHi Shardul, When I checked few similar posts on this (http://developer.teradata.com/tag/transpose) I got some idea; But in all these post I can see some key/index/supportive columns. Please give s...
3420 Mar 2016 @ 04:01 PDTDatabaseReplyHow to make substring with the second or third occurrence of a charaterUse STRTOK as suggested by Dieter: STRTOK('/a/bbb/cc/dddd','/',2)  
3317 Mar 2016 @ 02:58 PDTDatabaseReplyRemove characters after '-' in a stringJust use case to handle values with absence of 'x' as shown below: case when POSITION('-' IN myField) <> 0 then SUBSTRING(myField FROM 1 FOR POSITION('-' IN myField...
3202 Mar 2016 @ 10:24 PSTDatabaseReplyHow do I get the max date row?You can use qualify as shown below: drop table loc; create table LOC ( row_num integer, Loc_Num integer, Loc_Name varchar(50), DTTM timestamp ); insert into loc values (1,1234, '...
3123 Feb 2016 @ 12:28 PSTDatabaseReplyGenerate a Alphanumeric IDHi, Please refer the below link on generating the Sequential numbers Teradata. https://forums.teradata.com/forum/database/best-way-to-generate-the-sequential-numbers-csum-or-identity-columns...
3005 Dec 2015 @ 04:16 PSTTeradata StudioReplyUnable to connect to the database using Teradata Studio Express.Dear Dave, Its DOWN/HARDSTOP status. But when I'm trying to start the dbms its saying rdbms is crashed or session reset. Recovery in progress. Its in the same state for almost more than a hour.
2905 Dec 2015 @ 01:45 PSTTeradata StudioReplyUnable to connect to the database using Teradata Studio Express.I'm getting a warning message like DB is crashed.

Pages