#DateForumTypeThreadPost
3708 Mar 2016 @ 02:38 PSTUDATopicData Mover Email NotificationIs there a way or option in datamover to send email notification on job completion (failure/cancelled/successful)?
3615 Jul 2015 @ 02:18 PDTToolsTopicTeradata Query Scheduler multiple Servers/Services on single PC?Hi, I installed TQS Client and Server on one of my windows server (Windows 2008 Server R2 Enterprise). I have multiple Teradata Systems (like DEV, QA, PROD). How can I run TQS for all three diff...
3524 Apr 2015 @ 01:28 PDTDatabaseReplyChange based threshold option for collect statsif your scenario is to delete data and reload (turncate and load) threshold part will be skipped since data is deleted and for Teradata all data is changed and insertion again will not be calculate...
3421 Jan 2015 @ 09:29 PSTDatabaseReplyReplace View ( DDL ) inside a Stored Procedure TeradataHi Karthik, DDL can be used in Macro with these limitations: Only ONE DDL in a macro DDL should be the last statement in Macro So, you can replace one view in one macro as last st...
3304 Feb 2014 @ 07:48 PSTToolsTopicConvert HostData to actual record from Error TableHi, We have some jobs loading data from TPT which creates ET for duplicate records. Does anyone know how to convert Hostdata values into actual record from ET? I have limitations, can not user fa...
3217 Dec 2013 @ 03:01 PSTDatabaseReplytwo similar tables - very different import speedWhat utility you are using?
3112 Dec 2013 @ 03:24 PSTDatabaseTopicHow to grant UPDATE to DBC on DBC.IDCol Tables?I was reading an older post (http://forums.teradata.com/forum/database/reset-identity-column-counter) and concluded that somehow Update is possible for DBC tables (DBC.IdCol).  I've come-...
3011 Dec 2013 @ 08:23 PSTDatabaseReplySQL to transpose (row to column) any level (nth level) of data Here is your solution. I am placing full code so other gurus can correct it if one finds error or better solution.   CREATE TABLE myDB.SrcTgtMap ( TgtCol VARCHAR(100), Sr...
2910 Dec 2013 @ 09:25 PSTDatabaseReplyHow long it will take to insert 20 million rows to teradata table from java using jdbc drivers TYPE=FASTLOADCSV This might be helpful too. http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#BABFGFA2
2810 Dec 2013 @ 09:22 PSTDatabaseReplyHow long it will take to insert 20 million rows to teradata table from java using jdbc drivers TYPE=FASTLOADCSV I don't think there is an absolute answer of this, you might need to look at some bench marking results for this but still it will be highly dependent upon I/O and network/communication capacit...
2709 Dec 2013 @ 10:25 PSTDatabaseReplyForeign KeysThis is something about implementing hard RI and soft RI. I am trying to find some reference why Teradata is creating "_0" table but for the time being I can tell you ...
2606 Dec 2013 @ 02:11 PSTDatabaseReplyDefault date column not aligning in xcelExcel doesn't support date before 1900 and considering this value as text value. See for further details : http://exceluser.com/formulas/earlydates.htm
2506 Dec 2013 @ 10:12 PSTDatabaseReplyScript to compare two databases (Tables and Views definitions)If you have access on DBC then you can write SQL statement to compare text for TVM.CreateText.  You might need to join dbc.TVM  with dbc.dbase to get appropriate result.
2406 Dec 2013 @ 09:00 PSTDatabaseReplyneed a associated select query defined from view table in teradata?Its pretty strange, did you try same thing using BTEQ? Which provider you are using to connect SQLA? Is it ODBC or .Net Provider?
2304 Dec 2013 @ 09:06 PSTDatabaseReplyError 2618 Invalid Calculation Division by ZeroDid it work fine for you?
2204 Dec 2013 @ 08:49 PSTDatabaseReplyStoring result set as a variable in a procedureA variable can only store one value at a time, not multiple values. You can consider using cursor in SP to get recordset and pass it thru loop one by one.  
2104 Dec 2013 @ 08:42 PSTDatabaseReplyError 2618 Invalid Calculation Division by ZeroLet me look at this SQL, meanwhile can you try following sql and let me know if still getting same error? SELECT I.REPL_GROUP_NBR AS DMDUNIT ,'-' AS DMDGROUP , 'US_WMT_ST_'|...
2004 Dec 2013 @ 07:39 PSTDatabaseReplyError 2618 Invalid Calculation Division by ZeroI think we need to look at complete SQL Statement and it's logic. Seems this filter is causing 'return zero' somehow.
1903 Dec 2013 @ 02:30 PSTDatabaseReplyNeed guidanceAs Dieter already mentioned, more details are needed to pin point the exact problem. specially Spool size, spool allocation, table structure, Merge Statement and Number of AMPs. At a glance, it lo...
1803 Dec 2013 @ 02:20 PSTDatabaseReplyneed a associated select query defined from view table in teradata?Can you please elaborate what exactly you are looking for? If you just want to see the SQL (View DDL) then why don't you use SHOW VIEW? SHOW VIEW View1;  
1703 Dec 2013 @ 02:14 PSTDatabaseReplySplit the dates bi-weeklyFollowing might solve your issue or help you to solve this query. SELECT Start_Date, End_Date FROM ( SELECT calendar_date End_Date, ROW_NUMBER() OVER(ORDER BY calendar_date) RowNum FROM sy...
1603 Dec 2013 @ 01:30 PSTDatabaseReplyCount the number of words in a phrase using Teradata SQLSree, This might help you to resolve your issue. SELECT COUNT(*)+1 FROM ( SELECT SUBSTR(SENT,POS,1) SINGLE_CHAR FROM (SELECT 'COUNT WORDS FROM THIS SENATANCE FOR ME' SENT) A, ...
1503 Dec 2013 @ 12:54 PSTDatabaseReplyError 5505 Column data types cannot be specified with a WITH [NO] DATA clause.Thanks Khurram for the compliments. I sent you invite on linkedin, stay in touch there.
1403 Dec 2013 @ 11:29 PSTDatabaseReplyRe-writing a query interms of performanceIf you have option to revise PI, you can improve performance of this query. You might need to implement following in CUST_T table. This will help to maintain uniquness, support to other queries usi...
1303 Dec 2013 @ 10:01 PSTDatabaseReplyError 5505 Column data types cannot be specified with a WITH [NO] DATA clause. I tested this scenario using same statements, and it is working fine for me.   Versions details: SQL Assistant : 14.0.0.1 Database : 13.00.00.12 Provider : Teradat...

Pages