#DateForumTypeThreadPost
2011 Jul 2014 @ 11:20 PDTDatabaseTopicEXISTS and NOT EXISTS in Teradata Version 14.10I have heard that EXISTS and NOT EXISTS functions will not be preformance friendly in Teradata Version 14.10. If anyone has more information on this, please share.
1929 Apr 2013 @ 02:29 PDTDatabaseTopicCasting in PPI definitionHi All, I have a PPI table defined as like below, CREATE SET TABLE SAMPLE.TEST ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL, ...
1814 Aug 2012 @ 02:59 PDTUDAReplySQL Query to modify a column datatype lenght.!!! Not through 'Alter' rather create new column with varchar.
1706 Aug 2012 @ 11:07 PDTDatabaseTopicConcurrency Issue   Hi All,   I am facing concurrency issue now. My script have concurrent update on same record and  SELECT statement is executed before update in order to get the ...
1606 Jun 2012 @ 09:58 PDTDatabaseTopicNumeric value out of range All, I'm using Golden Gate to push data from Oracle to Teradata. Im getting below error.. Error Message: "WARNING OGG-01004 Aborted grouped transaction on 'DATABASENAME....
1506 Jun 2012 @ 01:56 PDTDatabaseReplyCreating UPI/USI on Primary Key coloumn As documentation says... "If you define a table and you do not specify a PRIMARY INDEX clause, NO PRIMARY INDEX clause, PRIMARY KEY constraint, or UNIQUE constraint, the default behav...
1425 May 2012 @ 03:41 PDTDatabaseReplyCollect stats on column vs on index Carlos, Using INDEX clause will access the index path to collect the stats resulting faster stats collection? -Sen
1325 May 2012 @ 03:29 PDTDatabaseReplyPrivelege issue Thanks ToddAWalter!
1222 May 2012 @ 01:18 PDTDatabaseReplyPrivelege issue Thanks Ulrich for the response! i got this issue before usually it show me database and object name but this time shows me "SYSLIB.rpad_2". Any idea what does this mean? -Sen
1122 May 2012 @ 10:44 PDTDatabaseTopicPrivelege issue Hi All, i have created a view, when i query the view im getting below error. SELECT Failed [3523] An owner referenced by user does not have EXECUTE FUNCTION WITH GRANT OPTION access to S...
1011 May 2012 @ 10:10 PDTDatabaseReplyFinding PPI Hi, If the data retrieval is based on specific range for example eventhough the table has 5 years of data but the most queries submitted against the table pulls only last two quaters. T...
910 May 2012 @ 10:03 PDTDatabaseReplyFinding PPI Hi, sel databasename, tablename from dbc.indices where indextype ='Q';    
804 May 2012 @ 03:24 PDTDatabaseReplyINSERT SELECT Performance mystery Hi, Can you check the PI values in your source tables, i guess your source table PI may be highly skewed. If your PI column is highly skewed, then it would impact performance while...
704 May 2012 @ 03:12 PDTDatabaseReplyDecimal to Varchar Issue Hi, You can cast it as integer or bigint to avoid those '.'. Make sure you are not missing precision values. sel cast(cast('12356' as decimal(10,0)) as varchar(20)) ; ---...
623 Apr 2012 @ 11:59 PDTDatabaseReplyCharacter Truncation Thanks all for the suggestions, below code seems to be fitting my requirement(may not be ideal solution :-)). substr(ip_address, 0,8+(position('.' in substr( ip_address,9)) )) as ip_...
530 Mar 2012 @ 12:11 PDTDatabaseTopicCharacter Truncation Hi All,   I have the values like below,  col1 ======= 66.249.71.204 186.104.145.143 190.110.152.52 200.83.137.118 201.241.3.149 190.20.3.0 186.78.90.0 ...
424 Oct 2011 @ 02:03 PDTDatabaseReply3806: Table/view/trigger name is ambiguous @TeraAbe, Its exactly the same reason. There was a table with the same name exists in my default database. @Carlos, Thats a typo as i cannot paste the complete query here. Sorry about ...
323 Oct 2011 @ 04:24 PDTDatabaseTopic3806: Table/view/trigger name is ambiguous All, One of my bteq failed due to the error :"3806: Table/view/trigger name tbl1  is ambiguous".   My script looks like this: ==================<bteq ...
231 Aug 2011 @ 04:35 PDTDatabaseTopicTable Growth using dictionary tables All,   Is there any dictionary tables i can the get the information about the table growth?   Like, Data in my "Table_A" has grown 40% in one month.  ...
125 Aug 2011 @ 12:28 PDTGeneralReplyDELETING DUPLICATES I NEED SQL QUERY IN TERADATA @akolla, The point here is, is there a way to do this through DML only. Looks like the suituation here is, in production system we need to cleanup the data but we don have the acces to ...