#DateForumTypeThreadPost
71316 Sep 2014 @ 12:23 PDTGeneralReplyWhat is the purpose of using DBC.SYSEXECSQL?it is about dynamic SQL. You can only execute complete SQL's which can be parsed at SP creation time without DBC.SYSEXECSQL. But sometimes you want to have a SP where you can pass a tabl...
71229 Aug 2014 @ 01:13 PDTToolsReplyTPT: How to forcefully fail the jobHow do you invoke TPT? Linux shell? -> control C Usually ETL tools also allow to kill current processes.
71120 Aug 2014 @ 03:56 PDTDatabaseReplyTo find number of null values in each columns of a tableyou can make also easily a macro out of this...
71020 Aug 2014 @ 03:55 PDTDatabaseReplyTo find number of null values in each columns of a tablemaybe this gives a hint. https://www.wolframcloud.com/objects/243ed5e8-84b7-4c78-b0d0-9ce967325025 add your databasename and tablename - hit submit this will generate an SQL which generates the ...
70919 Aug 2014 @ 08:13 PDTPrivate Forum
70807 Aug 2014 @ 02:21 PDTDatabaseReplyTactical queriesCheck the CacheFlag in QryLogV   From the documentation:   Possible Values for the CacheFlag Column T The query is found in step cache. S The query is a par...
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...

Pages