#DateForumTypeThreadPost
70724 Jul 2014 @ 02:19 PDTDatabaseReplyComplex SQL ScenarioCan you provide SQLs to set up the test data please. Will make it easier to check the options. How do you distinct rule 1 and 2 (e.g. rule 2 example data also is also comply to rule 1). Same is tr...
70621 Jul 2014 @ 07:06 PDTDatabaseReplyHow to check what values are passed to procedure call from qrylog table ?you have to change your SP to log the information. Using queryband could be efficient for example SET QUERY_BAND = "PROCEDURE_NAME=yourSP;PROCEDURE_IN_PARAM=param1name:param1value|param2name...
70518 Jul 2014 @ 02:31 PDTDatabaseReplySQL statement wantedTry the following:   create table t1 (OUTLET_ID integer, DATE_ID date, QUALITY_FLAG integer ) no primary index ; insert into t1 values (1,date-5,1); insert into t1 values (1,dat...
70417 Jul 2014 @ 04:43 PDTDatabaseReplyGroup by on a Group by not working as expected!!!Can you explain why you think you need the two group by? What is the difference to  SELECT EXTRACT(YEAR FROM D) AS Y, SUM(V) AS V FROM T1 GROUP BY Y ?
70308 Jul 2014 @ 12:36 PDTDatabaseReplyCan we able to perform all the ETL activites by using VIEWS ?????Check you TASM setting and discuss it with your DBAs
70208 Jul 2014 @ 12:32 PDTGeneralReplyteradata viewpoint from SQL assitanctcheck dieters comment at http://forums.teradata.com/forum/database/active-running-queries
70108 Jul 2014 @ 12:25 PDTGeneralReplytime difference in minutesthis should do  select cast('2014-06-16 23:33:52' as timestamp(0)) a, cast('2014-06-16 22:36:22' as timestamp(0)) b, a-b Minute(4) to Second c, extract(minute from c) + e...
70003 Jul 2014 @ 06:27 PDTGeneralReplyIf we see a GTT table definition,there is a LOG.Can anyone please tell me.From the documentation:     whether transient journaling occurs for a global temporary or volatile table or not. This option pertains to global temporary and volatile tables only. LOG...
69903 Jul 2014 @ 12:22 PDTDatabaseReplyCreate a table with a date column that has a default lenght (8)It is always easier if you share some example code... Some clarification - a date data type is stored as 4 byte. Always. What you can specify is the format how the date is shown, but this does no...
69830 Jun 2014 @ 12:23 PDTDatabaseReplySkewfactorValues < 1 are OK. You might not getting better even if you use a UPI - depending on your number of rows and number of vprocs.  But as so often there are no fix numbers to say what is acce...
69730 Jun 2014 @ 12:16 PDTGeneralReplyIn BTEQ if we want to go forward we use condititional logic (if ..then GO TO .Label name).By using BTEQ can we go backward?Hi, no, you can't go backwards with an .goto statement. Ulrich
69626 Jun 2014 @ 02:51 PDTGeneralReplyIf hash collision occurs,how can we rectify this issue.Hi, can you provide some more details of your problem? What is the issue with the hash collision?  Ulrich
69524 Jun 2014 @ 11:48 PDTDatabaseReplyTypes of Tablekindyour can run a   select tablekind from dbc.tables group by tablekind order by tablekind; so see which are currently existing in your system.  By the way tablekind is very much misslea...
69405 Jun 2014 @ 02:26 PDTDatabaseReplyHow to calculate a character occurance in a string in teradatawhich version are you on?
69315 May 2014 @ 11:24 PDTGeneralReplyNumber of bytes-BIGINTThere is no doubt - 8 bytes from the manuals - SQL Data Types and Literals "BIGINT values are stored as eight bytes with the least significant byte first."  
69214 May 2014 @ 01:01 PDTDatabaseReplyHow to calulate Skew on Join IndexThe join index is created by an SQL therfore using this SQL as a derived table should give you the right info. Something like   SELECT HASHAMP(HASHBUCKET(HA...
69113 May 2014 @ 04:46 PDTDatabaseReply incremental planning and execution (IPE)yes, I used "only" 1 Mio rows on the PPI table. But the SSI queries also contained a UPI access so should be pretty fast. I was wondering where to draw the line and was therefor asking f...
69013 May 2014 @ 12:19 PDTDatabaseTopic incremental planning and execution (IPE)Hi all, I am exploring the new IPE feature on 14.10. Very nice! But sometimes the explain is showing   "This request is eligible for incremental planning and execution (IPE) &n...
68906 May 2014 @ 12:52 PDTDatabaseReplyIdentifying Temporal TablesIn 14.10 the dbc documentation states that tables views should have the column TemporalProperty Further down you find the following description:   TemporalProperty Column The TemoralPrope...
68829 Apr 2014 @ 02:35 PDTToolsReplyCan we use where clause in TPT Export selectortry to replace all ' with '' within the select. Something like (''000362464WH'', ''20550K01A'');  
68728 Apr 2014 @ 12:20 PDTToolsReplyLoading carriage returns with TPT Load Operatorsad, sad...
68626 Apr 2014 @ 12:50 PDTToolsReplyLoading carriage returns with TPT Load OperatorWill it make in 15.0? It creates so much overhead if you have to deal with it in preprosessing. These social network sources are full of this as it all about free text fields...
68516 Apr 2014 @ 07:05 PDTThird Party SoftwareReplyBi tool cannot read from different databases in teradata?Hm, not so easy to answer. I am not sure that I understand how the dead lock occurs. Questions: is the read lock nessesary for you? Would lock row for access be OK? I would strongly avoid the cre...
68407 Feb 2014 @ 11:38 PSTAnalyticsReplyteradataR package and R 3.0.0Just verified the package at (see message from nonsleeper above) git clone https://github.com/Teradata/teradataR/ is just working fine. What kind of message to you get? R version 3.0.2 (2013-...
68307 Feb 2014 @ 10:50 PSTTeradata ApplicationsReplyTPT export and error code 2595P.S. the error does not occur at TPT startup. There is already some GB of data retrieved...

Pages