#DateForumTypeThreadPost
19415 Nov 2013 @ 03:19 PSTDatabaseReplyGet previous column vale till it reaches another not null valueBikky, I dont know why my previous post is published empty. But you can get detailed information about this claues at teradata info home. The URL is as follows: http://www.info.teradata.com/ht...
19315 Nov 2013 @ 03:17 PSTDatabaseReplyGet previous column vale till it reaches another not null valueBikky, You can get a detailed information about this clause at teradata info home. The URL is as below: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_...
19215 Nov 2013 @ 03:07 PSTDatabaseReplyGet previous column vale till it reaches another not null valueHi Bikky, I hope the following query will fullfil your requirement. SEL M.EMPNO AS MAIN_EMP, M.EFF_DT AS MAIN_DT, --L.TYPE_CD, MAX(TYPE_CD) OVER(ORDER BY M.EFF_DT RESET WHEN TYPE_CD IS NOT ...
19115 Nov 2013 @ 01:34 PSTToolsReplyProblem using Teradata import - making me crazy!!Hi Sure, Can you please paste some sample data from the file you want to import?  
19014 Nov 2013 @ 09:44 PSTToolsReplyUtilities interacting with mloadRaja, Probably you have got answer from Tom :)  
18914 Nov 2013 @ 04:31 PSTDatabaseReplyMove column data as rowsHi, If you want to put data in all columns into a single column then the technique advised by Raja will obviously work. But if you want to place the data in these column into a single row then you...
18814 Nov 2013 @ 04:28 PSTToolsReplyUtilities interacting with mloadRaja, Utilities are a mean to interact with Teradata database, Mload is istself a utility to interact with teradata database.  Can you please elaborate your question, what do you mean by &qu...
18714 Nov 2013 @ 12:35 PSTToolsReplyInstalling BTEQ / MLoad on Windows 7Hi, The installation of BTEQ and MLOAD is quite straight forward on Windows-7. You just need to run the setup.exe for TTU and the select the required components you want to install. You do not nee...
18614 Nov 2013 @ 12:31 PSTDatabaseReplyHave NULLs in DATE fields always been possible?Hi, All RDBMS should allow nulls to capture all the business scenarios, But it is Application designers decision to either keep the null, or some constant value instead of null to represent some b...
18512 Nov 2013 @ 10:07 PSTDatabaseReplyProblems with dynamic creation of Volatile tablesHi, The first thing is I am not sure you can create an index on volatile table. But if still it gives you that 0 rows have been processes. then the table is their, I think it is a problem with you...
18412 Nov 2013 @ 10:57 PSTDatabaseReplyCan we Have a Column Partition on a MLOADED table?Hi Rakesh, As per my knowledge Fatload,Multiload is not suppported with the following: To load a table with USI, NUSI Column Partitioned table cant be loaded with Multiload Tab...
18312 Nov 2013 @ 10:03 PSTDatabaseReplySQL MERGE Detecting Duplicate RowsIf you are using Merge statement in TPT Operator, then it inserts the UV violated rows into a table name with TableName_UV. You can analyse that table to get the rows not inserted due to duplicate ...
18212 Nov 2013 @ 02:18 PSTDatabaseReplyRecursive QuerySarah, So you main target is to get the latest_DND, Does this means that a DND goes through diffrent values? like at start it is 105 and at the current  value is 4008. from this data, I assum...
18111 Nov 2013 @ 02:20 PSTDatabaseReplyMove column data as rowsYour data output is not understandable, Can you please give some more description? and also paste the data in correct format? Like currently, it seems that you want to see this data in a coolumn! ...
18009 Nov 2013 @ 02:26 PSTDatabaseReplyRecursive QuerySarah, Can you please paste your recursive query code?   
17909 Nov 2013 @ 01:04 PSTGeneralReplyTeradata Express 13.0 for WindowsHi Srini, you can download a full working VMware edition of Teradata Express 13 and 14 from the link: http://downloads.teradata.com/download/database/teradata-express/vmware  
17809 Nov 2013 @ 12:54 PSTDatabaseReplyRecursive QueryHi Sarah, Yes you can use more than on table in source using joins. Syntax: WITH RECURSIVE <query name> AS (SELECT COL_list FROM A INNER JOIN B ON A.Col = B.Col UNION ALL <RE...
17708 Nov 2013 @ 11:08 PSTDatabaseReplyDelete or Drop a table if it already existsI believe if this code is working in SQL Assistant then it will run in any odbc compliant GUI. Have you tried it using alteryx?  
17608 Nov 2013 @ 03:10 PSTDatabaseReplyJoining tables from two different serversyou can consult the following thread: http://forums.teradata.com/forum/database/compare-two-database-tables-row-count-in-each-table-which-are-in-different-servers#comment-86684  
17508 Nov 2013 @ 01:49 PSTDatabaseReplyDynamic Table NamesI think you can create a parametrized macro to create a table for every month. just pass the current month in the parameter and execute the macro. To combine data from all of these tables, you can...
17408 Nov 2013 @ 01:45 PSTToolsReplySQL Assistant upgrade causing heartburn!Raja, The answer is yes, The use of Teradata studio is much easy, and provides more information in different windows. It is much easy to use for peaple coming from Microsoft background, especially...
17308 Nov 2013 @ 01:38 PSTDatabaseReplyJoining tables from two different serversHi, I think it would not be possible for a query to get data from two different servers. One alternative is to copy the smaller table on the other server and then run your query.  
17208 Nov 2013 @ 01:35 PSTGeneralReplyChange a tables datatype in a Column for JoiningHi, I agree with Vlad, if you convert the varchar column to Integer, the join will become much fast, and also storage will be saved. you can go for integer.   
17107 Nov 2013 @ 08:11 PSTToolsReplyWill the TTU 13.10 work against Teradata Database version 14.10?I think their will be no issue about the use of TTU 13.10 with 14.10 Database. You will not be able to take benifit of some 14.10 features but connectivity will not be an issue, especially in the c...
17006 Nov 2013 @ 02:23 PSTDatabaseReplyConditional statement in Teradata macroHi, in addition to the above sequence your string in WHERE Clause whould be enclosed in single qoutes, like this WHERE Department = 'Adult Medicine'  

Pages