#DateForumTypeThreadPost
26905 Dec 2013 @ 05:55 PSTDatabaseReplyMVC generated out of V14.00 statisticsHi Roland, Thank you for sharing your work, It would be great if you share your thaughts in a blog in Developer Exchange. Good Luck!  
26805 Dec 2013 @ 04:45 PSTDatabaseReplyrecursive tableBikky, As you do not have any other condition except the join condition. on the basis of information you provided, I belive you should add WHERE LEVL<10 to avoid any unexpected recursion. &nbs...
26705 Dec 2013 @ 04:41 PSTDatabaseReplyDistinct LogicHi Bikky, Hope the following query will dolve your problem, Or at least give you a start. CT TD3471.table1(name1 VARCHAR(10),name2 VARCHAR(10)); INS INTO TD3471.table1 VALUES('ABC',...
26605 Dec 2013 @ 03:57 PSTDatabaseReplyWhom can help me explain the ‘46.06:18:08’ time.Hi gerado, This query is not working for me, Have you tested it on your machine?  
26505 Dec 2013 @ 12:23 PSTDatabaseReplyrecursive tableHi Bikky, I am not sure what data do you have in in Merge_T table. Because it will depend on your data whether the recursion will stop after testing the condition and stop at some point, or it goe...
26404 Dec 2013 @ 10:27 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioSo you are using JDBC with LDAP? I have tried changing the authentication mechanism to LDAP, and it is much of the same.  I think it might be the issue with user you are using, if you are on...
26304 Dec 2013 @ 09:56 PSTDatabaseReplyWhom can help me explain the ‘46.06:18:08’ time.Hi, There are several options available in ODBC for how to treat date and time, like III, AAA etc, I tried them as well but it didn't worked.  But its always good to use time and date da...
26204 Dec 2013 @ 09:53 PSTUDAReplyTeradata Appliance 2500 seriesThanks gryback :)    
26104 Dec 2013 @ 09:50 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioNo, You do not have to create connection for each schema, But it is possible while making a connection you had specified some default schema, and then only that schema is visible in you database ex...
26004 Dec 2013 @ 05:23 PSTDatabaseReplyWhom can help me explain the ‘46.06:18:08’ time.Hi, as gerado has explained that even with a format the underlying data type do not change and the resulting arithmatic is simple INTEGER arithmatic not the Time arithmatic.  You can use the...
25904 Dec 2013 @ 04:06 PSTData ModelingReplyDelete Partition Vs Drop Partition?Raja, Thank you very much for the reponse, I am able to understand it to some extent.  It would be great if you can paste the queries.  
25804 Dec 2013 @ 03:59 PSTDatabaseReplyWhom can help me explain the ‘46.06:18:08’ time.Hi gerado, I agree with you to some extent, But convertin this to time is not solving the issue, Can you please try the following queries: --Converting literals to time SELECT CAST( '11:10...
25703 Dec 2013 @ 11:42 PSTGeneralReplyDoes Teradata move all columns of a table to SpoolOne more thing I forgot to add: Teradata determines the smaller table by multiplying the number of qualifying rows with the number of bytes in column to be projected. Smaller table size: Number o...
25603 Dec 2013 @ 11:38 PSTGeneralReplyDoes Teradata move all columns of a table to SpoolRaj, A very interesting question. As you know, Teradata got a fantastic optimizer. This optimizer do a lot of things to make sure the use of minimal system resources (CPU, Memmory, Spool etc) and ...
25503 Dec 2013 @ 11:17 PSTGeneralReplyTeradata seminars and eventsRaja, You are always welcome :)  
25403 Dec 2013 @ 10:23 PSTDatabaseReplyCount the number of words in a phrase using Teradata SQLThank you Kawish for sharing a robust version, It helps me learning another way to achieve this :)  
25303 Dec 2013 @ 10:21 PSTDatabaseReplyneed a associated select query defined from view table in teradata?I got your problem, I have faced this many times, SQL Assistant sometimes trim the result of show view or table due to its length.  What you can do is to use administrator, go to your databas...
25203 Dec 2013 @ 10:18 PSTDatabaseReplyError 2618 Invalid Calculation Division by ZeroHi, Can you please peovide the complete Where clause, Or the previous part of this AND condition? It will help us to understand the problem.  
25103 Dec 2013 @ 10:15 PSTDatabaseReplyWhy I do not see all the databases in Teradata StudioHi, it seems that you connection is filtering out some schemas. You can right click on your connection -> go to Properties -> go to default schema filter section and make sure that disable f...
25003 Dec 2013 @ 10:07 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in OracleThank you Ulrich :)  
24903 Dec 2013 @ 10:12 PSTDatabaseReplyError 5505 Column data types cannot be specified with a WITH [NO] DATA clause.Dear Kawish, You are the man I have always idealized throughout my career, from Info-Architects to GCC, But I am unable to connect with you. Can I have your email or some other link? I am even una...
24803 Dec 2013 @ 09:21 PSTCloud ComputingReplySAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceYou can get more info at the following link http://pk.teradata.com/News-Releases/2012/Teradata-Active-Data-Warehouses-Provide-Private-Cloud-Benefits-Today/?LangType=1056 Hope it helps you!  
24703 Dec 2013 @ 09:20 PSTCloud ComputingReplySAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceRaja, You can get more info at the following link http://pk.teradata.com/News-Releases/2012/Teradata-Active-Data-Warehouses-Provide-Private-Cloud-Benefits-Today/?LangType=1056 Hope it helps you!
24603 Dec 2013 @ 09:15 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in Oracle Ulrich,   Can we use Oracle UDF to do this? Just like we use oReplace?   just a thaught, please guide!    
24503 Dec 2013 @ 09:08 PSTDatabaseReplyTeradata equivalent function to FROM_TZ in OracleThanks Raja and Ulrich, I think I will have to go for Ulrich's approach to write a UDF.  

Pages