#DateForumTypeThreadPost
712 Nov 2015 @ 09:06 PSTDatabaseTopicAlternate Solution to Self JoinDear All, Need help with below situation.... Data id        date 100   6/6/2015 100   8/1/2015 100   9/30/2015 200 &n...
627 Jul 2010 @ 10:37 PDTGeneralReplyQuery to List the Alphabets in EnglishThank you Dieter. looks like we might need to create a stored procedure to find the same.
526 Jul 2010 @ 04:19 PDTGeneralTopicQuery to List the Alphabets in EnglishHi All, I got a idea to write a query to list all the aplphabets in english. I know its a useless one. but still thought of giving a try. except selecting the chars individually and doing union ...
420 Jan 2010 @ 04:42 PSTDatabaseReplyHow to find the no:of amps involved in storing the data of a table?I got the answer myself.......select hashamp(hashbucket(hashrow(PI columns))) from databasename.tablename;result :you can see the details of amp on which the data is stored....
320 Jan 2010 @ 01:50 PSTDatabaseTopicHow to find the no:of amps involved in storing the data of a table?Hi All,I want to know the no:of amps/Amp number details involved in storing the data of table. Is there any Way?EG: my table is having 1000 rows of data. My TD database capacity is 600 TB. having ...
219 Jan 2010 @ 07:12 PSTDatabaseTopicWhat is method or strategy to calculate the CPU utilized in running a Query?Hi All,Suppose, i am running a query on teradata database. I want to know how the various components interact in calculating CPU requested/utilized .Could someone explain in detail?Thanks in Advanc...
123 Jul 2008 @ 10:54 PDTToolsTopicCan we Use TRIM funtion in fastload script?Hi all,Need your inputs....One of my friend has written a fastload script and he included TRIM function for few fields and when tried to execute.... he got the error msg :RDBMS error 3618: Expressi...