#DateForumTypeThreadPost
69622 May 2014 @ 09:54 PDTToolsReplyNeed Help in Teradata FunctionsYes I tried with STRTOK(col, '|', 2), it is a bit easier. I m used to regexp and unix  these days :) . Thanks Dieter.
69522 May 2014 @ 04:21 PDTToolsReplyNeed Help in Teradata FunctionsJust few days back someone had similar problem. http://forums.teradata.com/forum/database/string-functions#comment-133182   example: select regexp_substr('P2|10000677|L','[^|]+&...
69422 May 2014 @ 03:17 PDTToolsReplyNeed Help in Teradata FunctionsYou can use  SUBSTRING or SUBSTR or REGEXP_SUBSTR.  
69322 May 2014 @ 12:47 PDTGeneralReplySpace Allocationsome examples; CREATE DATABASE abc    FROM def AS    PERM = 123456789    SPOOL = 123456789    FALLBACK    ACCOUNT= '...
69221 May 2014 @ 09:51 PDTDatabaseReplyre:spool spaceHow about stats collection? It can be due to more volume of data, demography ....  Nothing change ....Release document!!!!
69121 May 2014 @ 04:47 PDTDatabaseReplystored procedures with loop - queueingWill the below link of this gentleman help you? It is self-explanatory. http://developer.teradata.com/blog/georgecoleman/2011/05/using-derived-tables-as-a-shortcut-to-set-sql http://developer.ter...
69021 May 2014 @ 03:44 PDTData ModelingReplyBridge tablesWith limited understanding of scenario, I am thinking of   grouping  behaviours into a behavior group helper table. It has factors.This helper table in turn connects to dimension. I reme...
68921 May 2014 @ 02:54 PDTToolsReplyTeradata OleLoadHope this material can help you.  https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0CCkQFjAA&url=http%3A%2F%2Fwww.info....
68821 May 2014 @ 12:49 PDTGeneralReplywhy NUSI is allowed in MLOAD but not in FLOAD/This has been asked quite a number of times :). You could have  searched and seen like this link below.  http://forums.teradata.com/forum/analytics/why-fastload-does-not-support-nusi &n...
68721 May 2014 @ 12:34 PDTDatabaseReplyDBQL SQLTextInfo 3577: row size or sort key size overflowData modelers should be far-sighted from beginning and see to it that for joining  cases if  Unicode_To_Latin or Latin_To_Unicode conversions be avoided owing to performance issues.
68619 May 2014 @ 09:49 PDTDatabaseReplyError creating volatile table in version 14.10Is it because of upgradation?    My suggestion is first write the sql part and see the result (even if you dont have data). I hope you have baz field  too in aTable, because in yo...
68518 May 2014 @ 11:20 PDTDatabaseReplyfast load quotes fieldUsually I feel ENTER is not pressed. You can vi the file  and use ^ and $ or do head -n  or tail the file. I remember in one case where I had a daily job and read from a file. One day the...
68416 May 2014 @ 09:24 PDTGeneralReplyOREPLACE gives an error, how to confirm its availableUse select * from dbc.functionsV  ..... As far as I remember, oreplace was not there in 13.  
68316 May 2014 @ 01:10 PDTTeradata ApplicationsReplyPPII suggest you go through Teradata materials. Row-partitioned primary indexes are defined for tables that are frequent targets of range or row-partition-based queries and also case basis.&nb...
68214 May 2014 @ 04:13 PDTDatabaseReplycreating C UDF - issue with float outputDid you try to change with 1.0 / (1.0 + 0.2316419 )  too. It may be that it compiles differently. Just my thought.
68113 May 2014 @ 11:47 PDTGeneralReplyHow do I split a column between quantity and unit of measureI think you need to write a udf. In 13.1,  (regex) regular expressions may not be there. Just double check by running one small regex function. I hate writing  substr(col, 1,1) , obtain...
68013 May 2014 @ 10:10 PDTDatabaseReplyString FunctionsHave a look at regexp_substr example below: REGEXP_SUBSTR: select regexp_substr('hello:good:afternoon','[^:]+',1,1) val; select regexp_substr('hello:good:afternoon','...
67913 May 2014 @ 05:05 PDTDatabaseReplyNumeric or non-numeric valuesYes, it won't. nothing compares to udfs :). This is just a quick one, in  case that col does not have whitespace, special characters.
67813 May 2014 @ 04:41 PDTDatabaseReplyNumeric or non-numeric valuesCan you try something like this logic? select your_col  from your_table where upper(your_col ) (casespecific) = lower(your_col  )  (casespecific)
67712 May 2014 @ 01:45 PDTDatabaseReplyDelete taking more timeYou can check  your explain . Exists usually is faster like in other databases too.
67612 May 2014 @ 01:21 PDTDatabaseReplyTeradata Jobs AutomationIt is always advisable to have  scheduler, since jobs may take priorities, SLAs etc. and you told that Unix/Linux is also is out of question. You may try Window's  Task Scheduler in...
67511 May 2014 @ 11:46 PDTGeneralReplyColumn partitioning in Teradata 13.10Teradata columnar is introduced in  TD DB 14.0. So you need TD  DB 14.0.
67411 May 2014 @ 11:40 PDTGeneralReplyFunction overloading or Generic Functions in UDFsPlease refer to this link. I used to write C,C++ programs before but not advanced calling  in TD. http://www.info.teradata.com/HTMLPubs/DB_TTU_13_10/index.html#page/SQL_Reference/B035_1147_10...
67309 May 2014 @ 01:13 PDTGeneralReplydifference between HASH INDEX and SINGLE TABLE JOIN INDEXSTJI and HI , in terms of perfomance, are same.
67209 May 2014 @ 01:03 PDTDatabaseReplyStored procedureDid you try with these within your proc begin and end(Please double check the syntax and space)? CALL DBC.SysExecSQL('CREATE USER '||user_name|| ' FROM '|| owner1 || ' AS PERMA...

Pages