#DateForumTypeThreadPost
1214 Jun 2016 @ 04:59 PDTDatabaseReplyIs it an ordering - How do I generate a column that gives me the seq no of the selectThanks. I thought so. There was a rowid column that is no longer available. Can someone help me understand why? Is it to do with mpp architecture?
1114 Jun 2016 @ 02:48 PDTDatabaseTopicIs it an ordering - How do I generate a column that gives me the seq no of the select Hi All I have the following table CREATE MULTISET TABLE HASH_V ,FALLBACK ( hashVal INTEGER ) PRIMARY INDEX ( hashVal ); --data inserted in this order insert into HASH_V val...
1010 Aug 2015 @ 09:25 PDTPrivate Forum
931 Dec 2014 @ 02:02 PSTPrivate Forum
831 Dec 2014 @ 02:00 PSTPrivate Forum
705 Dec 2012 @ 12:38 PSTDatabaseReplyEntity-Relation Model for Teradata QueryHi how can we represent PI on the erwin tool if we select teradata for the database. when foing forward engineering how do we ensure that PIs are created and not PK. Regards Srividhya
607 Jun 2012 @ 10:43 PDTDatabaseReplyrecursive function you need to specify end confition for your recursive loop. it should not loop infinitly.
503 Jun 2012 @ 10:23 PDTDatabaseReplyduration calculation between dates which has overlap with other date ranges for same product Hi If you want to avoid OLAP functions then, You can create a intermidiate table with columns : Product_Name and Date. Convert the start and End date to single column and multipl...
416 Mar 2012 @ 12:12 PDTDatabaseReplycopying sequences based in timestamp Wunderbar Danke Ulrich!
315 Mar 2012 @ 06:30 PDTDatabaseTopiccopying sequences based in timestamp Dear All I have a base table as follows   LOGON_SESSION Activity_Time Activity_Date Activity_Type_ID 1...
211 May 2010 @ 01:58 PDTToolsReplyPerformance TuningTo start with the folllowing article in Teradata Magazine might help http://www.teradata.com/tdmo/v07n04/FactsAndFun/Services/StrikeItRich.aspx Also refer to Teradata Documentation - performanc...
117 Jan 2006 @ 03:55 PSTToolsReplyExport a variable length recordHi Just on similar lines, I need the ASCII '1F' (Non-printable control character' to be used as the delimiter. I have tried this using the BTEQ EXPORT but have not been successful. Can any body...