#DateForumTypeThreadPost
445320 May 2016 @ 07:37 PDTDatabaseReplyTIPS TO CONVERT DECIMAL TO VARCHARWhen you specify FORMAT = 'Delimited' in your TPT you don't have to cast every columns to VarChar, it's done automatically, but using default formats.   In your case you don&...
445220 May 2016 @ 03:13 PDTDatabaseReplyPort MS SQL Cursor to TeradataMost of the syntax can be converted easily (adding lots of semicolons), but returning the result of the counts is more complicated. You need an intermediate table to Insert the counts and then fina...
445120 May 2016 @ 02:45 PDTDatabaseReplyDistribution Data Function/SolutionOuch, your current aproach will product join Party and Channel. When you can apply QUANTILE logic to your problem there's no more product join and the mapping should be more stable. Try this (...
445020 May 2016 @ 01:55 PDTDatabaseReplyMacro vs Procedure - SQL SECURITYQ1: No. Q2: The database where the Macro is stored must have the necessary rights WITH GRANT OPTION.
444919 May 2016 @ 05:39 PDTTeradata StudioReplyUnable to launch Teradata Studio ExpressHi Arpita, Teradata Studio is only a database client used to connect to a database server. The server might be Teradata Express VM http://downloads.teradata.com/download/database/teradata-e...
444819 May 2016 @ 04:14 PDTDatabaseReplyDistribution Data Function/SolutionCan you show how you currently do it?
444718 May 2016 @ 01:27 PDTDatabaseReplyskew factorThe table will be smaller when you drop those columns (or COMPRESS them), at least a Full Table Scan will be faster.
444618 May 2016 @ 06:32 PDTDatabaseReplyColumn value is refered as Column_Name in another tableThere's no reason to avoid it, you'll get best performance with a huge CASE, this is a one-time effort, you can create most of it using a Select on dbc.ColumnsV like this: SELECT 'WH...
444518 May 2016 @ 05:44 PDTDatabaseReplyColumn value is refered as Column_Name in another tableStrange data model. This is a simple CASE: SELECT CASE WHEN A.XYZ = 'C1' THEN B.C1 WHEN A.XYZ = 'C2' THEN B.C2 END  
444418 May 2016 @ 02:02 PDTDatabaseReplyWho dropped the table in teradata?I really don't know why, but dbc.EventsV usually has an entry 'Logging Online Archive Off' when a table is dropped and the submitting User is also included :-)
444318 May 2016 @ 02:00 PDTDatabaseReplyhow to determine concurrent Instances/connectionA session (LOGON ...) is a connection. Within an application you can open multiple sessions.
444218 May 2016 @ 01:56 PDTDatabaseReplyskew factorThe table will only be skewed if the Primary Index is based on those columns. Of course it's strange when there's only a single value in a column, what's the business meaning? If you ...
444117 May 2016 @ 07:44 PDTDatabaseReplyhow to determine concurrent Instances/connectionWhat do you mean by connections and instances? By default there are 2 Parsing Engines per node, each supports up to 120 sessions, so usually it's 240 sessions * number of nodes.
444017 May 2016 @ 07:42 PDTDatabaseReplytemporary table questionAt least you got 23 more hours to read the manuals :) does not work is not a very precise error description, you probably didn't specify the COMMIT option correctly.   A direct translat...
443914 May 2016 @ 05:43 PDTDatabaseReplyNeed to exclude data in a specific monthWhen you have a close look at the data you should notice that it's not '2005 8', but '       2016          5'. Instead of casting two tim...
443814 May 2016 @ 05:32 PDTGeneralReplyMLOAD DELETE TASKHi Anil, no, if col2 is part of the PI there's no way to match NULLs using MLoad.
443714 May 2016 @ 05:32 PDTDatabaseReplyHow to Update a timestamp field in a table in Teradata to convert from GMT o CST including daylight savingTry if this works: UPDATE_TS + (EXTRACT(TIMEZONE_HOUR FROM UPDATE_TS AT 'America Central') * INTERVAL '1' HOUR)   Of course you will encounter problems with...
443612 May 2016 @ 10:22 PDTDatabaseReplyReplace the characters with a numeric values Hi Narasimha, oTranslate tarnslates individual characters, not ranges.  This removes all non-digits: regexp_replace('surya hjaukki 43516', '[^0-9]', '');   ...
443509 May 2016 @ 12:33 PDTDatabaseReplyNeed help finding correct start dates In TD14.10 you can also use FIRST/LAST_VALUE: SEL ... LAST_VALUE(NULLIF(ACCT_2, 0) IGNORE NULLS) OVER (PARTITION BY ACCT_1 ORDER BY START_DATE DESC ROWS UNBOUNDED PR...
443407 May 2016 @ 05:06 PDTGeneralReplyconvert 13 digit epoch time to date?The TO_TIMESTAMP issue is related to Daylight Saving time zones, but is either fixed in later releases or is based on your system settings (There are several dbscontrol settings which influenc...
443305 May 2016 @ 11:42 PDTDatabaseReplyQuery :: Find tables which are accessed by usersCheck if the DBQLObjTbl contains data.
443205 May 2016 @ 11:39 PDTTeradata ApplicationsReplyBTEQ - DELIMITEREXPORT REPORT was meant to be used for printinh, thus it removes all non-printable characters.   Use TPT with FORMAT = 'DELIMITED' instead.
443105 May 2016 @ 11:36 PDTDatabaseReplyBad data in table , need suggestion to isolate the problemYou should contact Teradata support immediately and tell them the long story :-)
443005 May 2016 @ 12:55 PDTDatabaseReplyBad character in format or data You could use a REGEXP_SIMILAR, but the easiest way is TO_NUMBER(column_abc), which simply returns NULL if it can't be converted to a numeric value.
442904 May 2016 @ 01:57 PDTDatabaseReplySecondary Index Concept1) There's only one PI per table, but sometimes you want/need to index more than one column :) 2) All AMPs + FTS

Pages