#DateForumTypeThreadPost
34101 Jun 2012 @ 12:55 PDTDatabaseReplyaggregation error check the OLAP version of AVG select day_of _calendar, avg(day_of _calendar) over () as avg_day, case when day_of _calendar < avg_day then 'less' else 'more&#...
34031 May 2012 @ 11:49 PDTDatabaseReplyNeed help in tuning a query Are these queries logged in DBQL? If yes, check if the resource consumption is really different. You might be faceing system workload issues.
33930 May 2012 @ 12:34 PDTGeneralReplyInsert and Delete in Merge Into ON need to specify the join condition between T1 and T2 You need to check the manual for the merge syntax. Why do you insist on the merge? Did you consider Begin Transaction; ...
33830 May 2012 @ 05:00 PDTConnectivityReplyUsing != throws an error in [TeraJDBC 13.10.00.03] not related to JDBC see http://forums.teradata.com/forum/database/it-seems-teradata-doesnt-support-as-not-equal-right  
33729 May 2012 @ 12:57 PDTGeneralReplyInsert and Delete in Merge Into you can't delete with merge. check the manuals
33629 May 2012 @ 11:09 PDTGeneralReplyInsert and Delete in Merge Into how about merge into T2 using T1 on t1.a = t2.a       and t1.status in (1,3) when matched then... ?
33529 May 2012 @ 10:26 PDTGeneralReplyInsert and Delete in Merge Into no additional conditions on the when not matched and t1.status should be part of the join condition check for example http://forums.teradata.com/forum/general/conditional-merge-into ...
33429 May 2012 @ 04:05 PDTGeneralReplyCatching ACITIVITYCOUNT value using PROCEDURE Which interface to you use to exec the SQLs? SQLA, BTEQ, Java, Perl?
33328 May 2012 @ 11:16 PDTDatabaseReplyUpadate Syntax just remove the "table"  update lci_work_tbls.wi_purge_tbls_list set delete_flag='N' where SERIAL in(149);
33223 May 2012 @ 11:38 PDTDatabaseReplyHow to move spaces when date is null in table while Fast export try coalesce(cast(CAST(B.EFF_DT AS DATE       format 'YYMMDD') as char(8)),'        ')
33123 May 2012 @ 11:23 PDTToolsReplySQL Assistant "show table" results and other things truncated Try to use .net connect? In other posts it was suggested to use .net.
33022 May 2012 @ 12:15 PDTDatabaseReplyPrivelege issue The forum seach is horrible but google search find these as welll ;-) http://forums.teradata.com/forum/database/problems-with-two-views-on-different-databases
32922 May 2012 @ 12:11 PDTDatabaseReplyvolatile table question no, they are session local. Check the documentation. Volatile Tables Volatile tables do not have a persistent definition; they must be newly created each time you need to use them. T...
32822 May 2012 @ 01:53 PDTDatabaseReplyAbout call Stored procedure in ASP why do you post this 6 times? Better open one new thread And without sharing your code you are unlikely to get the right help.
32721 May 2012 @ 08:48 PDTDatabaseReplyRemove FALLBACK option and Data from FALLBACK AMP 1. check dbc.tables -> ProtectionType 2. via Alter tables statement  3. you don't have to care about this. DB will release the space automatically
32620 May 2012 @ 11:05 PDTDatabaseReplystring Matching using teradata sql hm id 1 and 2 are raising the question if the key value need to be 100% equal to the matching part of the null rows. id 1 has ABC Corp Inc. and id 2 has ABC Corp Inc Indi...
32518 May 2012 @ 01:02 PDTDatabaseReplyFULL JOIN Not working as required The easiest thing is to set up a pice of test data (inlc. create table, inserts, SQL) and add it to the post. Which can others past to SQLA and can come up with an real solution - instead of gue...
32418 May 2012 @ 12:59 PDTDatabaseReplyFULL JOIN Not working as required OK, but I still don't get it what you want to do as I can't figure out the question behind this.   FROM T1   FULL OUTER JOIN (  Select ID,&nbs...
32317 May 2012 @ 10:39 PDTDatabaseReplyFULL JOIN Not working as required Are you sure that this is the query you run? Select ID,  Date,  Count(Col4) as D,  Count(Col5) as E,  Count(Col6) as F FROM T1 Group By ID, Date, ...
32216 May 2012 @ 11:45 PDTDatabaseReplySQL Question check dieters solution in http://forums.teradata.com/forum/general/need-help-merging-consecutive-and-overlapping-date-spans You would need to convert the dates to a period etc.
32116 May 2012 @ 07:33 PDTDatabaseReplyRollback data using permanent journals/Incremental Backup You need to read the manuals! Did you try? You should get pleanty of hints and exampels...   Permanent Journal Archive or Recovery To perform archive and recovery functions ...
32016 May 2012 @ 06:31 PDTDatabaseReplySQL Question on which database version are you? can gaps exists in the history? start and end overlap - which is included where?  
31916 May 2012 @ 01:33 PDTDatabaseReplyUNICODE to CHAR Translate - TRANSLATE doesnt work. If you don't want to lose any information - yes. If you consider the non latin characters in the unicode field as garbage you could use the "WITH ERROR" option in the translate...
31815 May 2012 @ 12:09 PDTDatabaseReplyUNICODE to CHAR Translate - TRANSLATE doesnt work. You can translate all latin chars to unicode but you can't translate all unicode chars to latin simply due to the reason that a latin char is stored in 1 byte and a unicode in 2 to 3...
31714 May 2012 @ 11:41 PDTAnalyticsReplyremove "whitespaces" and "." in a string UDFs will do this most efficient but  http://forums.teradata.com/forum/database/change-all-periods-in-a-column-to-forward-slash#comment-20723 might outline an way how to do it the h...

Pages