#DateForumTypeThreadPost
12816 Jan 2007 @ 02:42 PSTAnalyticsReplyIssue while cretaing tab delimited filesHi Parag,AFAIK there's no way to export special characters using REPORT mode in BTEQ, because that mode was ment for printing reports.Of course you could use DATA mode, but then you'll have to get ...
12715 Jan 2007 @ 05:29 PSTAnalyticsReplySQL ProblemHi Chung-Te,did you run the queries several times or just once?Maybe it was just blocked. If you use DBQL (including stepinfo) you can submit both queries and then check the query log for details.D...
12615 Jan 2007 @ 03:23 PSTAnalyticsReplySQL ProblemHi Chung-Te,both plans are the same (just the order of preparation steps for joins is slightly different), so the performance should be the same.I still think, the queries you posted are not your r...
12511 Jan 2007 @ 06:03 PSTDatabaseReplySQL ProblemHi Chung-Te,it's an Outer Join, so the result might be different, if the optimizer added that NOT NULL condition automatically.Regarding the slow execution, could you post more details about row co...
12410 Jan 2007 @ 04:23 PSTDatabaseReplyPerfomance for Interpretive vs ExecutableHi Jim,"BTW, does anybody know why the forum software replaces the word "P A R S E R" in my text with "p****r"?"Because it contains the four letter word "A R S E" and that f.....g forum software ch...
12309 Jan 2007 @ 06:06 PSTDatabaseReplyPerfomance for Interpretive vs ExecutableHi James,"What is EVL in the first place?"In german it's an acronym for "Einfach verkettete Liste", i.e. Linearly-linked List :-)(If a Teradata developer is going to answer that question, please ex...
12208 Jan 2007 @ 03:50 PSTDatabaseReplySample FunctionHi Sam,select * from tabsample when prod_code = 'AS' then 10 when prod_code = 'CM' then 10 when prod_code = 'DQ' then 10endDieter
12108 Jan 2007 @ 05:37 PSTDatabaseReplyUpdate statement consuming 6 days to executeHi Raghav,if you can create all those Updates using a Select, why don't you simply write a single update statement?update table1 from (select ... as cal_yr_no, ... as cal_mh_no, ... as...
12008 Jan 2007 @ 01:56 PSTDatabaseReplyUpdate statement consuming 6 days to executeHi Raghav,you must be joking, you typed 209324 update statements using Textpad?How do you know the values for each update? There must be some input data or table.Each upate is doing a Full Table Sc...
11905 Jan 2007 @ 12:29 PSTDatabaseReplyBTEQHi Alpesh,this is part of the command window: Properties -> options -> QuickEdit modeDieter
11805 Jan 2007 @ 12:27 PSTDatabaseReplyUpdate statement consuming 6 days to executeHi Raghav,how did you create the 209324 updates?You can probably reduce the number by using CASEs.How many rows are updated by each update?Could you post the table DDL? Updates will be extremely sl...
11718 Dec 2006 @ 06:55 PSTAnalyticsReplykeyword SS ?Hi Roopesh,ss is a shortcut for Set Session.Lots of two char combinations are reserved words, e.g.ct -> Create Tableeq -> EQualuc -> UpperCaseDieter
11622 Nov 2006 @ 07:12 PSTUDAReplyTeradata - RANK functionHi Latha,you're doing the RANK using old Teradata style, which is not recommended anymore.It's ranking for each combination within Group By.Simply replace it with SQL:1999 style:QUALIFY RANK() ov...
11520 Oct 2006 @ 04:43 PDTToolsReplymultiple layout in for a singlr fileHi Raul,if the input format is readable text or vartext, then you don't specify DECIMAL within the FIELD, it's CHAR or VARCHAR. The cast will be done automatically or by using CAST(col as DEC(..)) ...
11419 Oct 2006 @ 08:20 PDTDatabaseReplyUsing Sample Function.Hi Luke,the only way i can think of is: Build the query string within a Stored Procedure and use Dynamic SQL (dbc.sysexecsql) to insert/select into a Global Temporary table (Or create a Volatile Ta...
11319 Oct 2006 @ 08:14 PDTToolsReplymultiple layout in for a singlr fileHi Raul,ACCEPT and IF/ELSE are the wrong places, you have to redefine the input layout and use different APPLYs, e.g. .layout test;.field c1 * integer;.field c2d * decimal(4,1);.field c2v 3 varchar...
11218 Oct 2006 @ 06:23 PDTToolsReplyTo Eliminate Non-ASCII column Value records and to Filter control characters1. Unicode -> ASCIIselect TRANSLATE(mycol using unicode_to_latin)...where TRANSLATE_CHK(mycol using unicode_to_latin) = 02. Oracle's TRANSLATE is implemented as a UDF (called otranslate) & availa...
11118 Oct 2006 @ 03:16 PDTToolsReplymultiple layout in for a singlr fileHi Raul,yes, should be possible. Could you post some more details, file layout, example records etc.Dieter
11018 Oct 2006 @ 03:13 PDTToolsReplyInvalid FORMAT string and "MJ" at the begining of the fileHi Prasanth,1. You have to cast to a timestamp instead of a date:cast(max(A.UPD_DATE) as date FORMAT 'yyyy-mm-dd hh:mi:ss')2. '|' is a VARCHAR, concatenating CHARs and VARCHARs results in a VARCHAR...
10918 Oct 2006 @ 03:03 PDTDatabaseReplysubstring from dateHi Kavya,select substring(date_1 FROM CHAR_LENGTH(date_1) - 3)Dieter
10817 Oct 2006 @ 04:53 PDTUDAReplyfastloadFastLoad loads directly into the target table (worktable = targettable), that's why there's almost no overhead regaring permspace.If you check the tablesize of a FastLoaded table you'll see that pe...
10713 Oct 2006 @ 03:07 PDTDatabaseReplyselect a row previous from the Max value.Easy using OLAP functions:select * from ...qualify rank() over (partition by acct_id order by plcmt_end_dt desc) = 2Dieter
10610 Oct 2006 @ 02:59 PDTDatabaseReplyHelp on SQLHi Jag,what's "immediate before"? Ordered by date?Is (id,date,flag) unique?Is Data a single column or multiple columns?You just have to define how rows are grouped, this might produce the desired o...
10510 Oct 2006 @ 02:51 PDTDatabaseReplyHow to read Collect Statistics informationHi Koen,this has been covered several times on the Teradataforum, e.g.:http://www.teradataforum.com/teradata/20050128_081301.htmDieter
10410 Oct 2006 @ 02:41 PDTToolsReplyCalculate the number of months between two datesUse ANSI SQL interval arithmetic:select (date1 - date2) month(4)Dieter

Pages