#DateForumTypeThreadPost
425316 Mar 2016 @ 05:22 PDTDatabaseReplyFinding value in previous row in a partition What's your Teradata release? What's the number of rows on both tables and how often do you need to run this? What do you mean by "messy data", missing rows or additional rows? ...
425216 Mar 2016 @ 05:18 PDTDatabaseReplyPartial string matching requires character operandsThere's abolutely no need to test if a DECIMAL contains anything else but a valid value, and which decimal has more than 1000 digits?  
425115 Mar 2016 @ 12:50 PDTDatabaseReplyCopy data from one database to another on the same server What do you mean by "moved to a different infrastructure"?   If both tables share exactly the same DDL there's no faster way (should be a direct MERGE without spool in Explain)...
425015 Mar 2016 @ 12:47 PDTGeneralReplyCSUM(1), But Increment (NOT RESET) Based on Some Condition Oops, I forgot ROWS, sorry :) sum(case when status = 'YES' then 1 else 0 end) over (order by whatever rows unbounded preceding)  
424915 Mar 2016 @ 12:19 PDTToolsReplyTPT : multiple sources in an operator ?Is this what you want? http://www.info.teradata.com/HTMLPubs/DB_TTU_15_10/index.html#page/Load_and_Unload_Utilities/B035_2445_035K/2445ch13.107.02.html#ww11420932   Regarding job variables,...
424815 Mar 2016 @ 12:16 PDTToolsReplyBTEQ for linux installation Package DownloadODBC is available on Downloads. If you're a Teradata customer talk to your DBA to get the Linux TTU (including BTEQ) from T@YS.   Otherwise the Linux client is installed on TD Expr...
424715 Mar 2016 @ 12:11 PDTGeneralReplyCSUM(1), But Increment (NOT RESET) Based on Some Condition Assuming there's a column to order accordingly: sum(case when status = 'YES' then 1 else 0 end) over (order by whatever)   Btw, CSUM is deprecated syntax, there's ROW_NUM...
424613 Mar 2016 @ 03:33 PDTTeradata ApplicationsReplyM-load Error while executing scriptThat's the standard way to pass a script to a command line utility in Unix/Linux/Windows. https://en.wikipedia.org/wiki/Redirection_(computing)
424513 Mar 2016 @ 03:06 PDTTeradata ApplicationsReplyM-load Error while executing scriptThat's a shell script, but not an MLoad script, the Unix shell complains about missing commands like ".LOGTABLE" If you don't use shell features you run it using mload &l...
424413 Mar 2016 @ 01:47 PSTTeradata ApplicationsReplyM-load Error while executing scriptShow your exact script and how you call it on command line.
424313 Mar 2016 @ 01:19 PSTTeradata ApplicationsReplyM-load Error while executing scriptEach MLoad command must be preceded by a period and must end with a semicolon. Each Teradata SQL command must not be preceded by a period and must end with a semicolon.
424212 Mar 2016 @ 09:22 PSTDatabaseReplyCopy data from one database to another on the same server No, it's wrong. If you run a Teradata mode session every SQL request is automatically commited, no need for BEGIN/END TRANS. A DELETE can only use FastPath if the optimizer knows it will be c...
424111 Mar 2016 @ 06:24 PSTDatabaseReplyIncrease the size limit of teradata objects name from 30 characters to more.The same as in TD14.10, 128. http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/index.html#page/Database_Management/B035_1094_015K/appb.070.09.html#ww14482536
424011 Mar 2016 @ 04:36 PSTDatabaseReplyLoad JSON File into TD 15JSON is a Large Object and LOBs can't be indexed. But you might create that table using NO PRIMARY INDEX.
423911 Mar 2016 @ 04:33 PSTToolsReplyErrorcode 3798If you hit the VarChar limit, there's no workaround.   But you might simply switch to TPT which allowes exporting VarText without any manual concat within your query...
423811 Mar 2016 @ 04:30 PSTDatabaseReplyDoes compressing a "byteint not null" column help size or performance at all?There's a lot of details about compression in the Database Design manual, including calculations when it's usefull or not.     If there are two compress BITs available you will...
423711 Mar 2016 @ 04:25 PSTConnectivityReplyUserID/Password failure when attempting a connectionYou always get a "Failure 8017 The UserId, Password or Account is invalid.", it's just not telling you exactly what was wrong. Maybe your client suppresses this error?
423609 Mar 2016 @ 08:31 PSTUDAReplyconvert varchar to timestampHint: 23/11/  doesn't match MM/DD/ :-)   CAST(ab.Dt AS TIMESTAMP(0) FORMAT 'DD/MM/YYYYBHH:MI:SS')  
423509 Mar 2016 @ 04:13 PSTDatabaseReplyLoading SQL Server TimeStamp Varchar to Teradata Table via TPTNo DBMS/ETL-tool can automagically load dates/timestamps with a non-standard format.   Simply define the column as VARDATE in TPT: vardate(29) formatin 'mm/dd/yyyyDhh:mi:ssDTDZ' f...
423409 Mar 2016 @ 02:36 PSTDatabaseReplyneed to test a query using three diff datesYou simply use this in WHERE. But if you choose a date it's not random :) You must explain more...
423309 Mar 2016 @ 01:30 PSTTeradata ApplicationsReplyTeradata Syntax TroubleIf "active" is based on "inv.load_date > (CURRENT_DATE -2)" then you already retrun only active merchants. You might remove this conditon from WHERE and use:   ,Case...
423209 Mar 2016 @ 01:18 PSTDatabaseReplyneed to test a query using three diff datesYou can use CURRENT_DATE - RANDOM(0, 182) to get a random date
423108 Mar 2016 @ 02:04 PSTTeradata ApplicationsReplyTeradata Syntax TroubleWell, that's simply no valid SQL, I don't get what you're trying to do :-) Show the working query without that CASE and explain what you're trying to do...
423008 Mar 2016 @ 01:56 PSTDatabaseReplyDateAdd and DateDiff function in Teradata??Hi Peter, yep, it's that stupid 4-digit limit for intervals :)
422908 Mar 2016 @ 01:56 PSTConnectivityReplyQuery not working ODBC driver 15.10There's no YEAR or CONCAT in Teradata SQL, those are ODBC functions. The new version of ODBC doesn't support them anymore by default, you must either use an ODBC Escape Sequence {fn YEAR(....

Pages