#DateForumTypeThreadPost
3713 Feb 2013 @ 09:58 PSTDatabaseReplyTeradata Error Code 7693Can you put what is the error description and if possible the call statement that you use to execute the procedure ?
3613 Feb 2013 @ 08:38 PSTDatabaseReplyDBQLSummaryTblYou can try different documents on the below link (especially the B035-1093-067A one) http://www.info.teradata.com/templates/eSrchResults.cfm?prodline=&txtpid=&txtrelno=&txtttlkywrd=DB...
3511 Feb 2013 @ 06:07 PSTAnalyticsReplyHow to not to skip a RANK ?That's good. Something new to learn. Thank you.
3411 Feb 2013 @ 05:58 PSTDatabaseReplyHow to retrieve the Relative Record Number?I think I got what you try to do here now. Can you give an example how you want to update the bad dates ? I meant, with what you want to update the bad dates ? Where can we find the corre...
3308 Feb 2013 @ 05:44 PSTDatabaseReplyHow to retrieve the Relative Record Number?Sorry, I am confused now. If there are duplicate dates and you afraid of updating the both the dates thinking one could be valide ? As per your initial query, you check for the bad date from S...
3207 Feb 2013 @ 02:01 PSTDatabaseReplyInvalid TimestampTry like below (assuming the DATE format is MM/DD/YYYY. If not then, you can change it accordingly) SELECT (CAST( (CAST(TRIM(Stg.Fecha_Ejecucion_OOSS) AS CHAR(10)) || ' ' || CAST(...
3107 Feb 2013 @ 01:47 PSTDatabaseReplyHow to retrieve the Relative Record Number?If I understood you correctly, then below solution would solve your problem. SELECT a.blank8, b.rownum ( SELECT -- add PK , CAST(CAST(t.blank8 AS FORMAT'9(6)') AS CHAR(8)) FROM ji...
3007 Feb 2013 @ 10:25 PSTGeneralReplyFormat yyyy.mm.dd hh:mm:ss to ddmmmyyyy:hh:mm:ssNot sure if you really want, ':' between DATE and TIME, but if you do not then you can try below - SELECT CAST(UR_TIMESTAMP_FIELD AS TIMESTAMP FORMAT 'ddmmmyyyyhhmiss') (Instead o...
2906 Feb 2013 @ 05:50 PSTAnalyticsReplyHow to not to skip a RANK ?First, thank you both for your help. The solution provided by Qaisar would fell short a bit, but the solution provided by Carlos would work perfectly. Thanks again guys.
2805 Feb 2013 @ 02:06 PSTAnalyticsReplyHow to not to skip a RANK ?I don't think that will work because users want top 100 rank values. But for them ranking means not like teradata ranking. They don't want to skip a rank. With row_number, I will get unique...
2705 Feb 2013 @ 11:38 PSTAnalyticsTopicHow to not to skip a RANK ?Hi, I have a table with store #, item # and the sales with billions of records. I need to rank by the sales to find out the top 100 selling items. I can use the RANK function and find it out. Howe...
2631 Jan 2013 @ 11:14 PSTDatabaseReplyMERGE-INOJust remove the PI or partition column from below statement and it should work. SET D = G_T1.D,  E = G_T1.E,  F = G_T1.F,  G = G_T1.G,  H = G_T1.H ...
2531 Jan 2013 @ 10:53 PSTGeneralReplyIs there a limitation on the Merge statement and Rank Function?I don't think there is a limitation on RANK about last 2 digits of s(6). It works fine in my project. Please share the SQL if you can and will try to help.
2424 Jan 2013 @ 05:48 PSTDatabaseReplyTOP and Order byIt would do the order by first and then fetch top n records.
2317 Jan 2013 @ 02:18 PSTDatabaseReplySpace in the databaseThat is very helpful. Thanks.
2217 Jan 2013 @ 01:42 PSTDatabaseReplySpace in the databaseThank you. Do you have any suggesion for my second question ?
2117 Jan 2013 @ 07:04 PSTDatabaseReplySecondary IndexIf the stats are collected on the index (NUSI) and NOT on the column then stats would be dropped if you drop the index.
2017 Jan 2013 @ 05:52 PSTDatabaseReplySpace in the databaseIt worked fine. Thanks a lot !
1916 Jan 2013 @ 02:02 PSTDatabaseReplyIncrease the size limit of teradata objects name from 30 characters to more.You can refer to this post - http://forums.teradata.com/forum/database/teradata-table-naming
1816 Jan 2013 @ 01:56 PSTDatabaseReplySQL Query output from DBC table volatileIt is very hard to believe that ETL jobs in production keep creating/dropping permanent or global temporary tables. Volatile tables do not get written into data dictionary, so those should not come...
1716 Jan 2013 @ 09:07 PSTDatabaseReplyStored Procedure Compile ErrorsNot sure whether you have seen the below article on Studio Express - http://developer.teradata.com/tools/articles/teradata-studio-express If you check the discussion at the end of the article, so...
1615 Jan 2013 @ 01:28 PSTDatabaseTopicSpace in the databaseHi, I have couple of questions regarding database space. 1) how to find out how much space has been left in an existing database ? I know how to find out the total allocated space ...
1527 Dec 2012 @ 09:49 PSTDatabaseReplyAdd partitions to multi-level ppiCan you be more specific ? What exactly you want to extend ? The interval of the partition ?
1427 Dec 2012 @ 06:55 PSTGeneralReplyCollect() in oracle equivalent in teradata?First you need to create ranking of your base data and store into one table. Like below. INSERT INTO yourdb.yourtb2 SELECT DEPTNO ,ENAME ,RANK() OVER (PARTITION BY DEPTNO ORDER BY ENAME)&nb...
1326 Dec 2012 @ 01:45 PSTGeneralReplyCollect() in oracle equivalent in teradata?You can get the desired output using WITH RECURSIVE of Teradata.

Pages