#DateForumTypeThreadPost
2307 Mar 2013 @ 02:52 PSTDatabaseReplyTimestamp format not working to get the two digit yearHi, There is a dbscontrol parameter named Century Break. If century break is 0 then all years in YY are 19YY If century break is 100 then all years in YY are 20YY.  
2204 Mar 2013 @ 10:28 PSTDatabaseReplyWill volatile tables be dropped?Hi, Give it a try.. Set your database to your working database. then compile the sp. It will show warnings "table temp1,2,3 already exists". Then drop all VTs manually and execute the sp. It wil...
2113 Dec 2012 @ 09:22 PSTDatabaseReplyI am NEW to SQL writing and I am getting a error message ntl_prd_secvm.CUST_ACCT_LINE_V CALT left outer join ntl_prd_secvm.POS_TRANS_V POS on esf.sor_id=pos.sor_id and esf.cust_id=pos.cust_id and esf.cust_line_seq_id= pos.cust_line_seq_id and esf.in...
2013 Dec 2012 @ 09:04 PSTDatabaseReplyUser PROMPTHi, I tried the statement given by Adeel on my table. select * from T_test where dtmid = ?inputvalue1 It did prompt for inputvalue and returned rows. If for given input value you don't hav...
1901 Aug 2012 @ 09:56 PDTDatabaseReplyQuery to generate collect stats statement automatically Hi, Below statement will generate the collect stats statements for a given table in given database. You can create a macro for this and run it for all tables in your DB and save the collect ...
1804 Jun 2012 @ 02:19 PDTDatabaseReplyTeradata stored procedures Hi jerboa, Please check the execute, execute procedure previleges are granted to the user which you are using. If the previleges are correct then you can call existing stored procedures....
1710 Apr 2012 @ 02:28 PDTDatabaseReplyHelp on 7 days average - advance sql Hope this help: select "date", count(user_id) over (partition by "date" order by "date" rows between 7 preceding and current row) from x1 Rgds,
1605 Apr 2012 @ 03:11 PDTDatabaseReplyTABLE header has invalid partitioning. Hi, please check whether you have defined No rane or unknown partitions in your PPI definition. Rgds,
1504 Apr 2012 @ 04:00 PDTDatabaseReplyNeed Help in creating a copy of the Table structure without any secondary indexes and Partitions Hi, You can take column "columnname" from dbc.indices and store it in a variable and then use that variable in your query. Regards,  
1402 Apr 2012 @ 10:18 PDTDatabaseReplyNeed Help in creating a copy of the Table structure without any secondary indexes and Partitions Hi, This can help: Create Table DB1.TB1 AS (select * from DB2.TB2) WITH NO DATA; It will copy the table structure of TB1 to TB2. Say col2 is the PI of TB1. But above st...
1302 Apr 2012 @ 05:04 PDTDatabaseReplyCharacter Truncation Hi, Try this: sel case when substr(t.ip, char_length(t.ip)) = '.' then substr(t.ip, 1, char_length(t.ip) -1) else t.ip end from( sel case char_length(col1) when 15 then subst...
1207 Jun 2011 @ 05:17 PDTDatabaseReplyCoverting INTEGER value to Date format sel cast((cast('200' || '40205' as char(8))) as date format 'yyyymmdd') can work .........
1131 Dec 2010 @ 02:22 PSTGeneralReplyVolatile tablesHi, Following information could help you. We can define primary index on volatile tables. Secondary index creation is not allowed on VTT. And we can collect stats on VTT. We can collect stats...
1024 Aug 2010 @ 11:25 PDTTrainingReplyTeradata 12 CertificationHi All, It will be beneficial for you to read the documents which i have referred in previous post. Reading just 1091.pdf would not be enough I think. You will get complete knowledge if you go thr...
903 Aug 2010 @ 11:57 PDTDatabaseTopicPPI on JIHi, I have created JI on some tables. The largest table in base tables has PPI defined. When i had fired a partially covered query, JI was used. After that I have modified JI, created same PPI...
802 Jul 2010 @ 03:00 PDTTrainingReplyNeed help to find out Teradata certification materialHi All, Just navigate through www.teradata.com and you will find all the details you are looking for. Anyways here is the link: http://www.info.teradata.com/GenSrch/eOnLine-Srch.cfm and se...
730 Jun 2010 @ 09:58 PDTTrainingReplyTeradata 12 CertificationHi All, For non-Teradata associates could find information at http://www.teradata.com/t/teradata-certified-professional-program/ Internal associates of Teradata could refer the following det...
628 Jun 2010 @ 12:06 PDTTrainingReplyNeed help to find out Teradata certification materialHi, The WBT is available on teradata university website : www.teradatau.teradata.com On the website please search the catalog to find the wbt. And you can get docs in the setup folder(on your ...
525 Jun 2010 @ 03:47 PDTTrainingReplyTeradata 12 CertificationHi Vasu, Actually I havn't given V2R5 certification. I joined grads team of Teradata this feb and i have started with Basics Exam(TD 12) only. So I don't have any idea about difference between the...
425 Jun 2010 @ 02:30 PDTDatabaseReplyShow tableHi, Below is some information which would help. If you query to DBC.Tables, it has a column "Alternate text" which gives the most recent operation which had been performed on particular object....
325 Jun 2010 @ 01:41 PDTTrainingReplyNeed help to find out Teradata certification materialHi, I have cleared TD12 Basics exam in May10. I am suggesting following material to study(I had studied it at the time of exam prep) Docs(which come with the TD official setup) - First three ar...
224 Jun 2010 @ 01:42 PDTTrainingReplyTeradata 12 CertificationHi All, I have cleared Teradata Basics exam. The docs which come with teradata official setup helped me a lot. Those who are planning to give the basics one can refer to those docs. Thank You...
124 Jun 2010 @ 01:33 PDTTrainingReplyNeed help to find out Teradata certification materialHi Amruta, Which certification you are looking for? I mean which level. I can give information about first(Basics) level of certification.