#DateForumTypeThreadPost
54121 Sep 2012 @ 06:59 PDTDatabaseReplyDetermine Average Count by Day of Week So, what is your actual requirement? Why not sort by  ((CMTMT_DT - Date '1900-01-01') Mod 7) + 1   ? &...
54020 Sep 2012 @ 06:09 PDTDatabaseReplyOreplace limitationFrom the manual:   3577 Row size or Sort Key size overflow. Explanation: The user request generated a row of data or a sort key that exceeded internal Teradata database limitations (prese...
53920 Sep 2012 @ 02:51 PDTDatabaseReplyrestoring tables from older TD releases deliver strange messagesThis thread might explain the what and why. http://www.teradataforum.com/teradata/20101012_151552.htm I found the script in    /opt/teradata/tdat/tdbms/13.10.01.04/bin/post_dat...
53820 Sep 2012 @ 12:28 PDTDatabaseReplyDetermine Average Count by Day of Week As you see here you need to be very precise in the desciption of your problem as you might get different results. The main difference in the two solutions from Dieter and me is that Dieter is coun...
53720 Sep 2012 @ 12:19 PDTGeneralReplyWish list for forum developmentOne more wish: The default language in the Code editor is JAVA.  At least I post in > 90% SQL in a database forum. Can the default be changed to SQL?  
53620 Sep 2012 @ 12:12 PDTDatabaseReplyDetermine Average Count by Day of Week you need to count the number of days per weekday separatly and join this to your result set. Something like: select d.AREA_NM_TURF, d.DayofWeek, casT(d.CountbyDayofWeek as decim...
53519 Sep 2012 @ 11:56 PDTDatabaseReplyOreplace limitationIt has to be executed on Teradata ;-> What kind of limitation do you have in mind?
53419 Sep 2012 @ 11:54 PDTGeneralReplyForum email notifications temporarily disabledno, at least I can't see this icon on my mac in firefox and safari browser - see sceen shots attached
53318 Sep 2012 @ 01:39 PDTToolsReplyTPT script: Disconnecting the sessionYou didn't give any kind of information beside that you have a problem - not even the error code. So how do you expect that someone can help you? Minimum is to share the script and the log - ...
53213 Sep 2012 @ 08:18 PDTGeneralReplyA Wish List for future versions of Teradata. from release 13.10 on you can create SQL UDFs which hide complex code for example  Create FUNCTION YOUR_UDF_DB.to_date (in_year smallint, in_month byteint) RETURNS date LANGU...
53113 Sep 2012 @ 02:34 PDTGeneralReplyPI Hash Value Generation for Same Value and Different Data Type true - I pick always the wrong order ;-)
53013 Sep 2012 @ 01:14 PDTToolsReplyBTEQ - Cannot write hexa character in output file try select text (title'') from ( SELECT databasename,        tablename,        id,    &nbs...
52912 Sep 2012 @ 11:29 PDTGeneralReplyPI Hash Value Generation for Same Value and Different Data Type You are able to answer this question to your own try select rowhash(cast(123 as integer)) ;   select rowhash(cast('123' as varchar(10)));   Some are has...
52812 Sep 2012 @ 07:54 PDTGeneralReplyConverting Delete qry you need to share the explain and ddls of your tables
52712 Sep 2012 @ 07:52 PDTDatabaseReplyGet the next partition isn't it not just the "next months with data" data in this case? select * from vt_tst where col2/100 = ( select min(col2) / 100 from vt_tst where col2 >= (add_months(cas...
52610 Sep 2012 @ 07:21 PDTToolsReplyBTEQ REPORT There is not possibilty to get this automated. you would need to do it manually   select 'select what_ever from tab order by 2,3,5' (title''); Be carefull wi...
52510 Sep 2012 @ 05:00 PDTDatabaseReplyPivot Data by Month still no ddl and inserts... but in this case it should be simply   Select state_ind,           sum(State_Count ),  ...
52410 Sep 2012 @ 04:58 PDTAnalyticsReplyR functions & Teradata Hi Edoardo, no, it is limited to teradataR package. This package "translate" functions into SQL and execute the SQLs on TD.
52307 Sep 2012 @ 11:47 PDTDatabaseReplyPivot Data by Month Can you please provide a DDL and insert statement for your test data? It is not really clear if state_ind has the values '1 AL' etc. And does the source table contain already the...
52207 Sep 2012 @ 11:38 PDTGeneralReplyA Wish List for future versions of Teradata. Hi, the general place for Teradata enhancement request is http://www.teradata-partners.com/ER/submit Where it might be interesting to discuss new requirements in the forum as wel...
52107 Sep 2012 @ 12:10 PDTDatabaseReplyHow do I retrieve the most recent used autonumber?? Teradata is a MPP system, so data is distributed and processed in parallel. So this is implemented differently- In easy words: To become not sequencial the identity process is done Vproc spe...
52006 Sep 2012 @ 05:50 PDTDatabaseReplyString manipulation using macros You will have trouble to do this with standard functions like INDEX and SUBSTRING as you don't now how many %value% things are in the string. Minimum requirement would be to have some st...
51906 Sep 2012 @ 05:40 PDTAnalyticsReplyCounting working days so let's assume the following table  create volatile table vt_dates as ( select c1.calendar_Date from_dt, c2.calendar_date to_dt from sys_calendar.calendar c1 cross join ...
51805 Sep 2012 @ 05:41 PDTConnectivityReplyCalling a macro via JDBC From the JDBC documentation   Teradata Database Macros A Teradata Database macro consists of one or more SQL statements. Macros can be executed using Statement.execute() method....
51704 Sep 2012 @ 10:07 PDTDatabaseReplyDo macros only support ANSI sql? PS. it has to be right outer join or left outer join  

Pages