#DateForumTypeThreadPost
56607 Nov 2012 @ 10:41 PSTConnectivityReplyRODBC fails and teradataR crashes on RHEL6I would try JDBC connect on Linux check http://forums.teradata.com/forum/analytics/connecting-to-teradata-in-r-via-the-teradatar-package  
56505 Nov 2012 @ 10:04 PSTDatabaseReplySlow Left Join queryBut in this case it mean that for each matching S_SK your answer set will generate up to 14144 result  rows. Is that what you expect? Ulrich
56405 Nov 2012 @ 07:19 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthhm I mixed the 10 and 50... check also dieters posts in  http://forums.teradata.com/forum/tools/bteq-cannot-write-hexa-character-in-output-file if you have trouble with the newline in the e...
56305 Nov 2012 @ 07:14 PSTDatabaseReplyPurge the work tables cretaed a month before and create report with the list of work tables created last monthtry  SELECT DISTINCT 'DROP TABLE DB1.' || TABLENAME || ' ; ' !! case when row_number() over (order by tablename) mod 10 = 0 then '.hang 50;' else '' end ...
56205 Nov 2012 @ 07:06 PSTDatabaseReplySlow Left Join queryThe skew value of the table is irrelevant as it is reflecting the S_SK,C_SK combination. try  select top 100 hashrow(S_SK), count(*) from spa_usage1 group by 1 order by 2 desc PP...
56105 Nov 2012 @ 04:52 PSTToolsReplyHow to Find Database name using Proxyid/Service idSilence might be related to the fact of unclear understanding of requirements. What are you looking for? "database name using Proxy id/Service id"???????????
56005 Nov 2012 @ 04:50 PSTDatabaseReplySlow Left Join querysome observations - 1. "spa_usage1 contains app 54 million rows" vs. "The size of Spool 2 is estimated with low confidence to be 567,176,439 rows"  which is a 10x di...
55924 Oct 2012 @ 11:07 PDTDatabaseReplyHelp with SQLI guess rule 1 is not correct as sel COL1,dt,col3,col4 from vt_test group by 1,3,4,2 having count(*) > 1; gives null rows. -> all rows are first occurance... So try to explain it i...
55824 Oct 2012 @ 07:21 PDTDatabaseReplyReverse string search (right to left)?select cast((current_date (format 'DD-MM-YYYY'))as char(10)) as txt, substring(txt from characters(txt) - 3 for 4);
55708 Oct 2012 @ 12:18 PDTDatabaseReplyIs mload delete faster than the Bteq delete?Yes, it is faster due to the reason you already mentioned: It doesn't use a journal. It scans and deletes... But did you consider to 1. copy the 2% of data which remains into a new table 2....
55608 Oct 2012 @ 12:14 PDTDatabaseReplyHow to Use Round Function In TeradataThe keyword is RoundHalfwayMagUp its a dbscontroll setting and defines how Teradata is handling the rounding. Default is FALSE from the manuals: Purpose Indicates how rounding should be perfo...
55508 Oct 2012 @ 06:12 PDTDatabaseReplyError Code 6706: The string contains an untranslatable character.its likely to be - check Dieters reply on http://forums.teradata.com/forum/database/implicit-data-type-conversion-to-char-ends-up-in-unicode you can validate by create volatile table sql_...
55408 Oct 2012 @ 12:25 PDTDatabaseReplyTable Level ChecksumsYes there is. Come and join Partners 2012  Sunday 09:30 AM EST, Room: Baltimore 3-5 How to Compare Tables between Teradata Systems in a Dual Active Environment?
55304 Oct 2012 @ 11:49 PDTDatabaseReplyconvert string to date formatsee my last comment on http://forums.teradata.com/forum/general/a-wish-list-for-future-versions-of-teradata
55204 Oct 2012 @ 06:19 PDTDatabaseReplyCompile Stored Procedures in BatchIf I understand your question correctly the answer would be no: see Carries comment in  http://developer.teradata.com/blog/ulrich/2011/11/extract-and-analyse-database-object-dependencies
55103 Oct 2012 @ 09:31 PDTDatabaseReplyDBQlogTbl statementtype is null?Hm, the DBQL is indicating that the query was executed 8 times - 6 queries plans had been used from cache -> parsingCPUTime = 0. So maybe your code is not doing what you expect...
55003 Oct 2012 @ 07:52 PDTDatabaseReplyDBQlogTbl statementtype is null?you called ODBC via javascript? In the cases I saw this happen the query was only executed once - you can validate this on your own by checking the totalIO and AmpCPUTime values. They should be &g...
54903 Oct 2012 @ 12:52 PDTDatabaseReplyDBQlogTbl statementtype is null?Can you share your Java connection settings - without username and password? Do you connect with multiple sessions?
54803 Oct 2012 @ 12:48 PDTToolsReplyUsing FastExport with Teradata JDBC DriverAnd which number is correct? I don't fully get what you wanne do. Do you export the data or do you only wanne know the row count?
54726 Sep 2012 @ 12:36 PDTDatabaseReplyHelp in Recursive query requiredalternative  code avoiding recurisve query CREATE volatile TABLE T1 ( row_id INT NOT NULL, text VARCHAR(991) NOT NULL ) unique primary index (row_id) on commit preserve rows; IN...
54625 Sep 2012 @ 07:25 PDTDatabaseReplyHelp in Recursive query requiredConsider the udfs you could directly use them to extract your infos. Otherwise - I guess A,B,C etc are examples. So these strings can be of variable lenght? AAA|BB|CCCC| ? How long is your sour...
54525 Sep 2012 @ 05:55 PDTDatabaseReplyHelp in Recursive query requiredI still don't get what you wane achive But also check http://developer.teradata.com/blog/madmac/2010/03/a-few-basic-scalar-string-udfs These are quite usefull - for you the list function...
54424 Sep 2012 @ 05:41 PDTTeradata ApplicationsReplyQuery to convert Decimal(15) to date format 'yyyy-mm-dd'Asuming your decimal column has alwys dates in the format yyyymmdd the following should work select cast(19890523 as decimal(15,0)) as dt_in,           cast((dt_in - 190...
54321 Sep 2012 @ 08:00 PDTDatabaseReplyDetermine Average Count by Day of Week select d.AREA_NM_TURF, d.DayofWeek, casT(d.CountbyDayofWeek as decimal(15,3)) / w.num_of_days as AVG_COUNT from ( select day_of _week, CASE day_of _week W...
54221 Sep 2012 @ 07:57 PDTDatabaseTopicImplicit data type conversion to char ends up in UnicodeHi all, I am on 13.10. Why is an implicit decimal or integer to char conversion with coalesce resulting in character set unicode? create volatile table vt_a (a decimal(3,0), b integer, c date)...

Pages