#DateForumTypeThreadPost
21926 Nov 2013 @ 08:49 PSTDatabaseReplyrequired to get the records for last 6 monthsI just needed one value just to check the date format :) You can follow peters solution, if it is not working please let me know.  
21826 Nov 2013 @ 03:50 PSTDatabaseReplyrequired to get the records for last 6 monthsYes, it makes sense, can you execute the following query and paste the some date values here, Select order_date from sales;  
21726 Nov 2013 @ 01:17 PSTDatabaseReplyrequired to get the records for last 6 monthsIf you need me to produce a working query, I would need the structure of bothe the tables and some sample data to work on.  
21626 Nov 2013 @ 01:17 PSTDatabaseReplyrequired to get the records for last 6 monthsYes I am getting you, but what I want to take a look at the date format in your order_date column.  If this condition is not working then we might need to change the date_order format to subt...
21526 Nov 2013 @ 01:00 PSTDatabaseReplyrequired to get the records for last 6 monthsoops! Whats the data in your order_date column? Can you please paste 2-3 values from order_date?  
21426 Nov 2013 @ 12:13 PSTToolsReplyHow to split a Data Export by row value?I think then it would be good for you to use stored procedure, write a stored procedure to loop through a range you want to process, pass parameters of date or CustomerID.  Stored procedure g...
21325 Nov 2013 @ 11:44 PSTDatabaseReplyrequired to get the records for last 6 monthsHi peiter, you can add order_date - INTERVAL '6' MONTH in the where clause. Further you can partition this table to gain performance.  
21225 Nov 2013 @ 09:33 PSTToolsReplyHow to split a Data Export by row value?Hi, You can split your export data by using a variable in WHERE condition. e.g. you can put this select statement in a macro and then calll the macro, and pass the value as paramter for where clau...
21125 Nov 2013 @ 09:28 PSTTeradata ApplicationsReplyHow to Change the datatype of an existing Column Of an existing Table.Hi, You can consult the following two topics for this problem: http://forums.teradata.com/forum/database/how-to-modify-datatype-of-a-column-using-alter-table-command http://forums.teradata.com/f...
21025 Nov 2013 @ 09:18 PSTDatabaseReplyAny good training institude to learn teradataHi, In which area?  
20924 Nov 2013 @ 11:54 PSTDatabaseReplyAutomate my Teradata queriesYou can read the following blog to have a basic idea of Bteq http://www.teradatahelp.com/2010/09/introduction-to-teradata-utilities-bteq_02.html  
20824 Nov 2013 @ 11:50 PSTDatabaseReplyAutomate my Teradata queriesHi Parteek, You need to put your SQL code inside Bteq as said by Ulrich. BTEQ is a Teradata sql processing tool, if you need further information about Bteq, do let me know. if you have an idea of ...
20721 Nov 2013 @ 10:22 PSTDatabaseReplyTeradata Data Types to OracleHi Santanu, The following link might help you, http://docs.oracle.com/html/B10543_01/apa.htm  
20621 Nov 2013 @ 10:00 PSTDatabaseReplyDatabase Performance: large Table getting redistributed causing performance problemsHi Naga, You do not have mentioned the 2nd table's information. If the 2nd table is small you can create a hashindex on that to avoid redistribution,  even if you have proper stats colle...
20521 Nov 2013 @ 11:15 PSTGeneralReplyCollecting StatsFahad, I have a few recomnedations: Try to collect stats always, as it helps the optimizer to choose best plans for query execution. As the column has only two possible values, you c...
20421 Nov 2013 @ 05:52 PSTGeneralReplyMVC ToolWhat do you mean by MVC tool? If you are talking about Teradata Multi Value Compression, then you only have to define the Compression values in the Column definition which you want to compress and ...
20320 Nov 2013 @ 03:14 PSTGeneralReplyProcess of Change of PI in skewd tableHi Omar, You can analyse the distinct values in columns, less the distinct values, more the column is a candidate for compression.  For example, Gender, country, Codes etc,  To make a ...
20219 Nov 2013 @ 06:48 PSTDatabaseReplyUnable to access application tables.I believe Tom is right, Its just a rights issue, get the Select rights and you will be able to access this info.  
20119 Nov 2013 @ 04:46 PSTDatabaseReplyROW_NUMBER() same valuesIf you Col1 is an index column then Teradata will generate same rowhash for 'Abc' in both the rows and still the result will be same :)  
20019 Nov 2013 @ 04:05 PSTDatabaseReplyROW_NUMBER() same valuesHi Fazol, It is the order by clause that determines which row will get number one and which row number 2 within each partition. if there is any specific requirement to number a row with same value...
19918 Nov 2013 @ 11:12 PSTGeneralReplyProcess of Change of PI in skewd tableHi Omar, To change the PI of a table you will need to recreate the table, But before making changes, make sure to analyse the demographics of the candidate PI columns. Once you have choosen a good...
19818 Nov 2013 @ 11:06 PSTToolsReplyTeradata JDBC Driver User Guide for 13.10/14.0Hi Sanjay, You can download the all the drivers and related sfotwares from the following: http://downloads.teradata.com/download  
19718 Nov 2013 @ 10:06 PSTDatabaseReplyHow to simplify query that runs out of spool space?Hi Vamsi, You can fin some of the new features introduced in TD 14 at the following: http://pk.teradata.com/News-Releases/2011/Teradata-Database--the-Smartest-Database-for-the-Smartest-Analytics/...
19618 Nov 2013 @ 10:01 PSTDatabaseReplyTwo Point CommitHi Kishore, You can the following URL for  the details about two phase commit in Teradata. http://teradatafaqs.blogspot.com/2012/01/what-is-two-phase-commit-2pc-in.html http://www.info.tera...
19515 Nov 2013 @ 03:40 PSTDatabaseReplyGet previous column vale till it reaches another not null valueTry this: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1145_111A/Ordered_Analytical_Functions.083.010.html  

Pages