#DateForumTypeThreadPost
24403 Dec 2013 @ 05:23 PSTDatabaseTopicTeradata equivalent function to FROM_TZ in OracleHi, Is there any built in function available in Teradata with similar functionality as FROM_TZ  function in Oracle? Or we will have to do it using INTERVAL or CAST function?   &n...
24303 Dec 2013 @ 05:17 PSTGeneralReplyTeradata seminars and eventsRaja, You can see a list of web sminars on this link: http://pk.teradata.com/web-seminars/ Also you can find a plenty of events at http://pk.teradata.com/ Resources tab.  
24203 Dec 2013 @ 05:06 PSTCloud ComputingReplySAP AG,Siebel,Salesforce.com, Microsoft CRM,Amdocs -cloud serviceWhat about TERADATA ACTIVE DATA WAREHOUSE PRIVATE CLOUD?  
24103 Dec 2013 @ 03:15 PSTData ModelingTopicDelete Partition Vs Drop Partition?I have not done much work with partitions in Teradata, I just wanted to know the diffrence between Deleting a partition and sroping a partition?  and what are limitations with these commands?...
24003 Dec 2013 @ 03:09 PSTUDATopicTeradata Appliance 2500 seriesWhat is Teradata appliance 2500 series? I just read in a book that most of the Teradata utilities are not being supported with this series, Is it being depricated?   
23903 Dec 2013 @ 01:54 PSTDatabaseReplyRounding hour and minute from time stamp to the closest hourTry this: SELECT CURRENT_TIME(0), CASE WHEN EXTRACT(MINUTE FROM CURRENT_TIME(0)) - 30 >= 0 THEN CURRENT_TIME(0) + ((60 - EXTRACT(MINUTE FROM CURRENT_TIME(0))) *...
23803 Dec 2013 @ 01:18 PSTData ModelingTopicMini Cylpack vs Cylinder migrationHi, Can anybody please elaborate a clear difference of Mini Cylpack and Cylinder Migration? I am confused about these two concepts :(  
23702 Dec 2013 @ 04:02 PSTDatabaseReplySelecting a column based on DATE along with GROUP BYHi, You can try this SELECT (SEL UID FROM TD3471.TEMP WHERE dt=(SEL MAX(dt) FROM TD3471.TEMP )) AS GID, MID FROM TD3471.TEMP ORDER BY 2;  
23601 Dec 2013 @ 07:59 PSTDatabaseReplyConversion of Time to INTERVALWow, thats great. I was unable to think that way.  Thank you!  
23501 Dec 2013 @ 07:31 PSTDatabaseReplyConversion of Time to INTERVALDieter, Yes the TIME -TIME is an interval, But is there any possiblity to convert the result of above query to HH:MI format?  
23401 Dec 2013 @ 07:21 PSTData ModelingReplyPPI VS NPPIThank you Raja for the response, But I was thinking if there is a term used for Table Partitioned by a column other than PI. It was just a confusion and I got it laters :)  
23301 Dec 2013 @ 07:19 PSTCloud ComputingReplyTD-14 VM Ware IssueHi Dieter, Infact I did nothing special, just rebooted the VM, and it goes directly yo commandline mode after boot.  I am unable to share screen shot here. But it happens always when I resta...
23201 Dec 2013 @ 07:17 PSTData ModelingReplyPPI VS NPPIHi Diether, Thank you very much for the kind response, it was a confusion, I got the answer laters :) Even if partition is not based on PI, the distribution is based on PI, and the rows are still...
23101 Dec 2013 @ 01:35 PSTCloud ComputingTopicTD-14 VM Ware IssueHi, I have downloaded the TDExpress14.10.00.02_Sles11_40GB.7z.  I was trying to run it using VM ware player, At first attempt it runs fine in a GUI mode, but once I restarted it, It rebo...
23001 Dec 2013 @ 01:21 PSTDatabaseReplyError 7628 happened in TRANSACTION mode whiling trying to insert a table that has "WITH CHECK OPTION" foreign key≈Hi, You have answered your question in the last line, when you use WITH CHECK OPTION , refrences are checked at transaction level. If you are inserting a row in the parent table and then...
22930 Nov 2013 @ 03:54 PSTData ModelingTopicPPI VS NPPIhi, When we partition a table based on PI it is called PPI, and if a table is not partitioned on PI, then it is called NPPI, my question is that is there any specific terminology about a table par...
22830 Nov 2013 @ 03:49 PSTDatabaseTopicConversion of Time to INTERVALHi, I was working on a scenario and build the following logic, I need to convert the time output from this case statement to INTERVAL HOUR TO MINUTE. SELECT CURRENT_TIME(0), CASE WHEN ...
22728 Nov 2013 @ 04:03 PSTDatabaseReplyRe-writing a query interms of performanceHi Bikky, I was just analysing your scenaio, and got this link, just read the disadvantages of PPI and I hope you will be able to optimize your query. http://www.info.teradata.com/htmlpubs/DB_TTU...
22628 Nov 2013 @ 02:46 PSTDatabaseReplyCount the number of words in a phrase using Teradata SQLHi Sree, I have created a stored procedure to count the number of words in a string, hope it will help you! REPLACE PROCEDURE SAMPLES.WordCount ( IN InputString VARCHAR(4000) , OUT WCoun...
22527 Nov 2013 @ 09:45 PSTDatabaseReplyError 5505 Column data types cannot be specified with a WITH [NO] DATA clause.HI, You are defining a column name as id, and in PI clause you are specifying item_id which do not exist. else the statement is working fine.  you can try CREATE VOLATILE TABLE wow ...
22427 Nov 2013 @ 09:28 PSTDatabaseReplyNeed help getting rid of parcel length error in BTEQ scriptHi Diether, That is a good addition to my knowledge, thanks for correcting me :)  
22327 Nov 2013 @ 09:46 PSTDatabaseReplyNeed help getting rid of parcel length error in BTEQ scriptHi, When you import a file using BTEQ Import, Bteq try to combine as many records in a parcel as it can fit. So in your case you parcel length is exceeding the length CLI can handle. You can avoi...
22226 Nov 2013 @ 11:29 PSTDatabaseReplysum of amout for the date falling in the respective month i.e months wise sum amount is requiredTry this SELECT SUM(sales) AS Monthly_Sales FROM Sales WHERE salesdate BETWEEN Start_Date AND END_Date; You can replace the start and end date with start and end date of the period for ...
22126 Nov 2013 @ 09:35 PSTDatabaseReplyExplain plan for set tableHi Vlad, you are welcome, but this time I do not agree with you :)    
22026 Nov 2013 @ 09:00 PSTDatabaseReplyExplain plan for set tableI agree with Vlad, the number of steps will be same with set and multiset tables, but the duplicate row check will be made at block level, byte by byte.  

Pages