#DateForumTypeThreadPost
267831 Mar 2014 @ 11:59 PDTDatabaseReplyWhen system write encounters backup read lockYour scenario is wrong :) dbc.errortbls is not used by Mload, it records Error Tables for MERGE, i.e. CREATE ERROR TABLE ...
267716 Mar 2014 @ 02:38 PDTDatabaseReplyHow is the Node Decided@HTH: the Bynet doesn't look at the table header, it simply does a lookup in the Hashmap. Each system has a so-called Hashmap which is specifically created (during sysinit) for that system an...
267609 Mar 2014 @ 09:42 PDTDatabaseReplyfinding links between two col values..If there are cycles you need to detect them, the only way is to built a materialized path and check if the current value is already included. And if there's no way to find out the actual start ...
267508 Mar 2014 @ 02:58 PSTDatabaseReplyCOMPRESSION for TIMESTAMP field in TD14Compression for TIME and TIMESTAMP was introduced in TD14.10
267408 Mar 2014 @ 02:55 PSTDatabaseReplyqualify rank() over (partition.....questionHi John, some questions: - is rnk based on the same sort as start and end date, i.e. are the dates for the first row within the group always the lowest? - is rnk actually a unique number without...
267307 Mar 2014 @ 01:48 PSTDatabaseReplyutf8TO16 : why is it Latin to unicode conversion function when utf8 itself is unicode encoding?UTF8TO16? There's no such function built-in. There's only TransUnicodeToUTF8 and TransUTF8ToUnicode, but those are compression UDFs (changing internal storage from UTF6 to UTF8 to sav...
267207 Mar 2014 @ 01:42 PSTDatabaseReplyfinding links between two col values..You just have to find the root level, then i's easy :-) WITH RECURSIVE match(grp, col1, col2, levl) AS ( SELECT col1, col1, col2, 0 AS levl FROM val AS t1 WHERE NOT EXISTS ...
267106 Mar 2014 @ 08:28 PSTDatabaseReplyUsing Teradata in OLTP applicationHi Sri, how many rows are returned by the 2nd query?  Are there collected stats on that column? Can you share the Explain? I would expect 5 sequential "single-AMP retrieve" steps...
267006 Mar 2014 @ 08:21 PSTConnectivityReplyCan I use the Teradata ODBC Linux drivers with Mac OS XThere's a Teradata Client for OSX including BTEQ, TPT and ODBC. But it's located on Teradata's patch server, so probably only for customers and not freely available :(
266905 Mar 2014 @ 10:39 PSTDatabaseReplyQualify solution SELECT * FROM tab QUALIFY ROW_NUMBER() OVER (PARTITION BY ENT_ID ORDER BY CASE WHEN PRODUCT_TYPE = 'GHP' THEN 0 ELSE 1 END, CURRENT_BAL DESC) = 1 &...
266805 Mar 2014 @ 10:33 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemHi Karthik, imho you can't choose the shop with the maximum number of items, e.g. shop 1: 2,3,4,5,6,7 shop 2:1,2,3,4 shop 3: 5,6,7,8 shop 1 + 2 or shop 1 + 3 has less items than shop 2+ 3
266705 Mar 2014 @ 05:45 PSTDatabaseReplyJoin Issues - Need help in most efficient way to solve the problemHi Karthik, i don't think there's a simple solution, especially without Stored Procedures. As it's only 300 items you might use bit-functions to create a bit-string and then BITO...
266605 Mar 2014 @ 05:22 PSTDatabaseReplymy confusion about LEFT JOIN A WHERE-condition on the inner table changes the result of the Outer join to an Inner join. The optimizer is smart enough to know that and when you check explain there's no outer join. There&#...
266505 Mar 2014 @ 04:30 PSTToolsReplyBTEQ losing header comments of view definitionsHi Matthias, afaik you can't do that as-is in BTEQ. The only way i know is to move the comment after the REPLACE, e.g. REPLACE VIEW SampleDB.TestView AS /* Header comment: This ...
266403 Mar 2014 @ 07:11 PSTDatabaseReplyDate as IntegerIf you seriously want to implement SCD you need the right to create SPs. The code will mostly be generic, so as a basis you can simply use existing code from any RDBMS. Or use Teradata's Temp...
266303 Mar 2014 @ 03:15 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesCan't be "a few weeks ago", don't use the one on top, scroll down :-) Version: 14.10.01.01 Released: 28 Feb 2014
266203 Mar 2014 @ 03:02 PSTDatabaseReplyCalculate Performance Impact of Secondary IndexIf it's the first index on a table: - a USI will double the number of IOs for Inserts/Update/Deletes and it needs communication between primary and secondary AMP, runtime might be doubled. - ...
266103 Mar 2014 @ 02:52 PSTConnectivityReplyTeradata SQL Assistant 13 with Teradata .Net providerDid you check if PROD is actually resolved to an ip-address? nslookup prod or nslookup prodcop1
266003 Mar 2014 @ 02:44 PSTDatabaseReply"6706 Untranslatable Character" error caused by character string exceeding a fixed length?Is this a literal string you're trying to insert? Then i would expect the limit to be 15500 Unicode characters and a 3738 error: 3738 String is longer than 31000 characters. Explanation: Quo...
265903 Mar 2014 @ 02:34 PSTToolsReplyTPT 14.10 output to named pipe and then gzip to final filesHi Andy, there was a new version of TD Express a few days ago, 14.10.01.01, you might try if this includes TPT 14.10.00.03. Dieter
265803 Mar 2014 @ 02:29 PSTDatabaseReplyQuery band in procedure. SET QUERY_BAND ';' UPDATE FOR SESSION;"As the error indicates, you can't set a Queryband on session level in SPs, it's simply not supported. If the question is "why it's not supported?", i don't know, there mig...
265727 Feb 2014 @ 08:49 PSTAnalyticsReplyLevenstein Distance AlgorithmEdit Distance and N-Gram string UDFs In TD14 there's a built-in EditDistance UDF based on the Damerau-Levenshtein Distance algorithm.
265627 Feb 2014 @ 08:09 PSTToolsReplyFast export and mload in vartext mode - Data item too large for field issueHi Cheeli, yes, the first two bytes indicate the length of the VarChar, you need an OutMod or a Unix shell command to strip them off. The max range of an INT is 10 digits, but there's a sign,...
265527 Feb 2014 @ 07:58 PSTDatabaseReplyQuery regarding Column and row mergeOf course, simply add it, when you need it.
265427 Feb 2014 @ 07:55 PSTUDAReplyCast and format Hi Pio, what do you expect? A DATE minus a DATE results the number of days difference,but you substract a string from a date: DATE '2033-12-31' - '0131210' Because this is not d...

Pages