#DateForumTypeThreadPost
2617 Feb 2015 @ 08:40 PSTDatabaseReplyHow to write a select query for all columns in a join environment but only show a subset There is something missing in your query. I cannot see the second table after the "inner join" ...
2517 Dec 2014 @ 03:00 PSTDatabaseReplyExtra space is getting added with data while loading data into varchar data type column Please respond on this
2416 Dec 2014 @ 11:17 PSTDatabaseTopicExtra space is getting added with data while loading data into varchar data type column Hi All,  I am getting  extra space while inserting integer data into varchar data type column. Please explain the reason behind this.   create volatile table rowhash_my,no log (...
2304 Dec 2014 @ 09:32 PSTToolsReplyMload utility is loading unexpected data into table Hi Fred, I amend the code as you suggested .Still i am facing the same issue. Can some one help me on this ?   Thanks, Sai
2203 Dec 2014 @ 01:50 PSTToolsTopicMload utility is loading unexpected data into table Hi All, I have build below Mload script to load the data into table.Sample data and final output in table  also given below   .LOGTABLE tdbname.Logtable001_mld; .logon <Dbnam...
2112 Jul 2013 @ 02:57 PDTDatabaseReplyHow to spell out numeric value in English words by select query.So we can't spellout beyond 9999
2012 Jul 2013 @ 02:55 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Thanks a lot Dieter.
1912 Jul 2013 @ 12:52 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Hi Dnoeth, THnaks for the information.It is really usefull for me. I have one more question. Can't we spellout the numbers in terdata? In requirement have a column having 4 degit numbe...
1812 Jul 2013 @ 12:45 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Hi  Dnoeth, THnaks for the information.It is really usefull for me. I have one more question. Can't we spellout the numbers in terdata? In requirement have a column having 4 degit numb...
1711 Jul 2013 @ 09:54 PDTDatabaseReplyHow to spell out numeric value in English words by select query.Hi All, Can any one help me on this? Thanks sai
1611 Jul 2013 @ 10:18 PDTDatabaseTopicHow to spell out numeric value in English words by select query.Hi ALL,   Can any one help me how to use Element (SP) in To_char function to spell out the number in english words? I am using TD 14 verion> Below content mentioned in TD14 doc about SP...
1510 Jul 2012 @ 08:56 PDTGeneralTopicHow to display the similar column value only one time in query? HI , Can some one helpme how to display the similar column value only one time in query?   ex: Code  id ===   === Pune   105 Pune &...
1409 Jul 2012 @ 06:33 PDTGeneralReplyHow to display first 3 and last 3 records from a table Thanks Dnoeth.
1309 Jul 2012 @ 09:15 PDTGeneralTopicHow to display first 3 and last 3 records from a table Hi All, Can someone help me how to display the first & last 3 records from atable?   Ex: id     name 101   sai 102   ...
1206 Jul 2012 @ 08:57 PDTGeneralReplyHow to find the parent and child relationship between tables in Terdata by using Dictonary tables? Hi  Waq, I did not find single table from the above set of dictonary tables. even though there is a user difined tables in my database. So,is there any other solution to get the dat...
1105 Jul 2012 @ 09:39 PDTGeneralReplyHow to find the parent and child relationship between tables in Terdata by using Dictonary tables? CAn you frame the query with above tables?   Thanks, Sai
1029 Jun 2012 @ 10:02 PDTGeneralTopicHow to display the last 3 characters of lastname? Hi, In oracle we used below query to display the last three characters of last_name. SELECT SUBSTR(LAST_NAME,-3) FROM EMPLOYEES;   Can someone help me how to perform in ...
929 Jun 2012 @ 09:18 PDTGeneralTopicHow to find the parent and child relationship between tables in Terdata by using Dictonary tables? Hi, In my project have many Facts and dimentions.I would like to know the relationship between those tables by using Query. Does terdata store parent child relationship at dictonary tabl...
827 Jun 2012 @ 08:18 PDTGeneralTopicHow to generate multiple records from single record Hi, Can some help me how to generate mutiple records from single record without UNION/UNION ALL.   Example: Source: Id   Customername    account...
727 Jun 2012 @ 08:10 PDTDatabaseReplyCan we use GROUPING ,GROUPING_ID,Grouping Sets Thanks mjasrotia
626 Jun 2012 @ 09:31 PDTDatabaseTopicCan we use GROUPING ,GROUPING_ID,Grouping Sets Can some one help me how to use GROUPING ,GROUPING_ID,Grouping Sets in terdata?
526 Jun 2012 @ 09:22 PDTDatabaseReplySQL QUERY help Thanks for your Reply Dieter! Yes, I need this query to test one of the report in my project.  
425 Jun 2012 @ 09:39 PDTDatabaseTopicSQL QUERY help Hi All, I have following data in table level. Can some one helpmeon this?   Category          barcode    &nb...
314 Apr 2012 @ 10:56 PDTDatabaseTopicHow to display each row in a table into multiple times Hi All,   I am  new to Teradata. Please let me know how to display the single row into multiple time. In oracle : ====== saelect  *  from  table ...
209 Apr 2012 @ 09:04 PDTGeneralReplyWelcome to the Teradata Developer Exchange discussion forums! Hi, Can anyone guide me how to find the Parent and child relationship between tables in teradata.   Thanks in advance.

Pages