#DateForumTypeThreadPost
119615 Dec 2014 @ 02:31 PSTDatabaseReplyRow Counts of all Tables in a databaseTry something like this:  Select          'Select ' || '''' || trim(databasename) || '.' || trim(tablename) || ''',...
119512 Dec 2014 @ 09:36 PSTDatabaseReplyRow Counts of all Tables in a databaseone way is :You can develop the dynamic sql to get the select dbname.tablename, count(*) From dbc.tables where tablekind =  't'  and databasename = 'yourdb..' or you can ...
119411 Dec 2014 @ 04:50 PSTDatabaseReply(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds I am not aware of the restriction if there is any in the DBS settings .....
119311 Dec 2014 @ 12:08 PSTDatabaseReplyJoin on different datatypeAFAIK, in all databases, there is performance issue when there is data type difference.
119210 Dec 2014 @ 11:58 PSTDatabaseReplyDefine Foreign Key for a tableYou can see examples from here and traverse back and forth: http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details.012.071.html
119110 Dec 2014 @ 11:47 PSTDatabaseReplyRemove the first 4 characters in a stringWhich TD version you are in? One way is :You can think of using regexp_instr to get the position of 'from'. Then use subtsr.
119010 Dec 2014 @ 11:12 PSTDatabaseReply(DBQL- DBC.Qrylog ) How to convert ELAPSEDTIME (HH:MM:SS.00) to Seconds There may be better ways. However, I am thinking this way: SELECT EXTRACT (hour FROM '13:36:15.5') *3600 a,EXTRACT (minute FROM '13:36:15.5') *60 b, EXTRACT (second FROM '...
118910 Dec 2014 @ 03:49 PSTDatabaseReplyNew to Teradata and SQLYou can see this link: http://www.info.teradata.com/ . In it, you can find "Teradata Database, Tools and Utilities Release". You can choose which version you are in(13.10,14,....). I...
118823 Nov 2014 @ 08:44 PSTDatabaseReplyneed the query for the o/p.Hw about your previous to previous? you can try this way: select eid, ename, max(case when flag='previous' then loc end) over(partition by eid,ename  order eid,ename ) oldloc, ...
118723 Nov 2014 @ 07:54 PSTDatabaseReply issue with WITH clause and throing eroor like WITH IS NOT ALLOWED IN A SUBQUERY OR A VIEWAs far as I see, it does not make a difference. As for the calculations , I suggest to have a look at the recommendations in this link. https://forums.teradata.com/forum/database/space-in-the-dat...
118623 Nov 2014 @ 12:58 PSTAnalyticsReplyairlines query - cross value duplicate eliminationIs it something like this what was done by Dieter? http://forums.teradata.com/forum/database/help-on-below-sql#comment-137894
118521 Nov 2014 @ 09:29 PSTDatabaseReplyTemporary TablesDo you mean to say that you want to insert into volatile table like for example: create volatile table rkt as (select ..... from ....and v485.src_cd='MWEDGE1') with data primary index(xy...
118421 Nov 2014 @ 09:10 PSTDatabaseReply issue with WITH clause and throing eroor like WITH IS NOT ALLOWED IN A SUBQUERY OR A VIEWCan with clause option be inserted? I think they are for reporting only. I am not sure, since the output can be variegated. Let us learn from others who may have done this.
118321 Nov 2014 @ 03:49 PSTDatabaseReplyConnecting Multiple Teradata ServersThink of Unity loader and Unity mover.
118220 Nov 2014 @ 11:02 PSTDatabaseReplyREGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16.  You can try for Non ascii chars check, just to double check: substr(CIRCUITID , 1,1) >= '80'xc substr(CIRCUITID , 2,1) >= '80'xc substr(CIRCUITID , 3...
118120 Nov 2014 @ 08:18 PSTDatabaseReplySplit delimited Column into separate RowsLooks like Dieter has already tipped you to use TD_SYSFNLIB.STRTOK_SPLIT_TO_TABLE in your previous post, since you are already in 14.
118020 Nov 2014 @ 07:58 PSTTeradata ApplicationsReplyTeradata 14 CertificationYou have not mentioned specifially what you want. It can be you want the the links or pointers or anything. You can refer to the previous posts like and see the hyperlinks therein: http://forums....
117920 Nov 2014 @ 04:58 PSTDatabaseReplyGet the user details about who aborted the query Hope you can get from Logonsource from dbc.dbqlogtbl  :). Also other details are there, like querytext.... or other details from there can be macthed with from dbql.
117820 Nov 2014 @ 12:35 PSTDatabaseReplyTable Lock in TeradataDiva, I dont remember in Informatica how it is done. But in Ab Initio, you can put in phases. How about locking? I m thinking in this direction that if it is a script, you can check by locking ta...
117719 Nov 2014 @ 09:40 PSTDatabaseReplyIdentify the queriesI am not able to understand clearly, what you want to do. Do you use viewpoint? or DBQLs....
117619 Nov 2014 @ 07:52 PSTDatabaseReplyTeradata Data MaskingYou can think of a home-grown solutions that suit most befittingly your organization standards like udfs, XSPs or think of tools that work well with Teradata..... IRI,Protegrity..... Even thru BAR...
117519 Nov 2014 @ 09:46 PSTDatabaseReplyREGEXP_SPLIT_TO_TABLE Error - Unexpected failure while attempting to convert UTF8 to UTF16.I do not have SQL assistant. Did you try in bteq? If you can share the script on what you are doing like  how your table description is....and sample values... example like how you select.....
117418 Nov 2014 @ 11:34 PSTAnalyticsReplyHOW ? Vertical Merger Turn Standard SQL?You can try thus, say: select id1,regexp_replace(tdstats.udfconcat(trim(name||id2)),'"','',1,0,'c') from your_tabul. group by 1
117318 Nov 2014 @ 08:52 PSTDatabaseReplyTable Block SizeMy viewpoint: Teradata 14.10 , you can increase upto 1 MB. Increasing the block size can reduce I/O contention. Metadata exhauting  read is minzimized. But having fewer blocks, may result int...
117217 Nov 2014 @ 10:34 PSTDatabaseReplysliding window merge joinYo could have read the design doc :) A Direct Merge Join cannot be used when one table is partitioned and the other is not, or when both tables are partitioned, but not partitioned identica...

Pages