#DateForumTypeThreadPost
30311 Mar 2008 @ 03:49 PDTDatabaseReplyvinay_144@hotmail.comIt's always the same way using any kind of connection:call myproc(myparam);Dieter
30211 Mar 2008 @ 03:48 PDTDatabaseReplyTASM InformationWhat kind of information are you interested in?There are some dbc views with data about rejeceted/delayed queries:TDWMEventHistory, TDWMEventLog, TDWMExceptionLog, TDWMSummaryLogThe TDWM data itsel...
30111 Mar 2008 @ 03:41 PDTToolsReplyNo More spoolspace errorHi Rajiv,it's three tables, but only one join condition join -> cross joinDieter
30007 Mar 2008 @ 07:19 PSTAnalyticsReplyConvert Text to Proper Case is huge problmeLess dirty:install the availabe Oracle UDF library and simply run.select initcap(cityname)from tabDieter
29907 Mar 2008 @ 07:19 PSTAnalyticsReplyConvert Text to Proper Case is huge problmeLess dirty:install the availabe Oracle UDF library and simply run.select initcap(cityname)from tab
29807 Mar 2008 @ 07:14 PSTDatabaseReplySQL QuestionHi chanduks,it's easy to solve using recursion. There's probably another solutiuon doing some tricks with aggregates, but i can't remember where to find it, so i'll do the simple one:with recursive...
29707 Mar 2008 @ 07:09 PSTDatabaseReplyFinding Continuos SpanHi Samit,this solution is quite similar to Joe's:SELECT emp, MIN(start_date) AS start_d, MAX(end_date) AS end_dFROM ( SELECT emp, start_date, end_date,-- check if the previous date p...
29623 Feb 2008 @ 10:06 PSTDatabaseReplyHow to declear Macro Variable?This seems to be a bug in some versions of SQL Assistant, instead of submitting both the CREATE and the EXEC as one block using F5, highlight the CREATE, submit it and then do the same with the EXE...
29523 Feb 2008 @ 10:01 PSTDatabaseReplyPartitioning with several columns"in the early design stage we offered a solution storing one month in one table"This is partitioning by month, too, it's just done manually instead of automatically.If you use a PPI by month you'll...
29422 Feb 2008 @ 04:44 PSTDatabaseReplyHow to declear Macro Variable?You simply missed the final semicolon before the closing bracket:and PRDCT_TYP_CDE=:prod;);Dieter
29322 Feb 2008 @ 03:07 PSTDatabaseReplyHow to declear Macro Variable?Of course this works in SQL Assistant or any other query tool, only Stored Procedures need a file to run the COMPILE command in BTEQ.Dieter
29222 Feb 2008 @ 12:36 PSTDatabaseReplyHow to declear Macro Variable?Varaibles are defined after the macro name and accessed using a colon in front of itREPLACE MACRO georgexu ( eom_date DATE ,product CHAR(3) ,member_age INT ,enroll_status CHAR) AS (SELECT *FROM...
29122 Feb 2008 @ 12:32 PSTDatabaseReplyUse Declare keyword in triggerYou can't use DECLARE within a trigger, only Stored Procedures.But you could call a SP from a trigger, i think since V2R6.2.Btw, row triggers might be quite slow, better try to write a statement tr...
29022 Feb 2008 @ 12:26 PSTDatabaseReplyINDENTIFY GLOBAL TEMPORARY TABLESHi Rodrigo,in TD12 the dbc.tvm.CommitOpt is carried over to the dbc.tables view.Before that the only way to identify GTTs is a HELP DATABASE, which also returns the CommitOpt:'D' or 'P' -> GTTDi...
28922 Feb 2008 @ 12:20 PSTDatabaseReplyDifference between Perm / Spool / Temporary SpaceThe concept of perm/spool/temp is fully explained within the manuals, e.g.:Database AdministrationCHAPTER 3 Space ConsiderationsAndSQL Reference: Data Definition StatementsChapter 2: SQL Data Defin...
28822 Feb 2008 @ 12:15 PSTDatabaseReplyLT,WT,ET,UV tables> the scripts did not get aborted even after all the records went into error table.MLoad will stop after ERRLIMIT errors in the acquisition phase, but not in application phase, because some data...
28722 Feb 2008 @ 12:07 PSTUDAReplyHow we can use timestamp with timezone in teradata(Eqv to from_tz in oracle)What do you mean by "same like in oracle"?Exactly the same format? There's only UTC +/- time zone in Teradata, no GMT or EST.Or something different? It looks like the same answer for me.Dieter
28622 Feb 2008 @ 11:59 PSTUDAReplyNotify Exit RoutineThe SysAdmin.TPumpStatusTbl is updated once a minute, so this is the first case:"TPump is about to update the Monitor Interface table". If you add the NOMONITOR option the "Interim Run Statistics" ...
28522 Feb 2008 @ 11:49 PSTUDAReplySpace management in TeradataThere's the Data Dictionary manual with details about all columns within dbc views.And there'sDatabase AdministrationCHAPTER 3 Space ConsiderationsBe careful when using the dbc.allspace, it's a com...
28422 Feb 2008 @ 11:39 PSTUDAReplyStop Teradata services from command prompt> Are there many reasons to be specified ? if so what are they?You can key in anything you want, this text is just used as an explanantion for the reset within the dbc.software_eventlog.> do...
28322 Feb 2008 @ 11:33 PSTUDAReplyEXISTS vs. INIn almost any case there will be no difference between an IN-subquery and an EXISTS-correlated subquery, the optimizer will rewrite both to a join. Compared to a JOIN there's also hardly any differ...
28202 Feb 2008 @ 09:30 PSTUDAReplySQL query to Teradata SQLHi Rakesh,what's the datatype of r_update_date, it can't be datetime, looks like an integer/decimal with julian day within year and that dateadd converts it to a date? CURRENT_DATE - CAST(CAST(r_u...
28101 Feb 2008 @ 07:35 PSTDatabaseReplyranking in teradata...Of course you can produce a rank using a (cross-) join based on non-eqality, but the performance of such a solution will be horrible.So why don't you simply use the existing RANK?Dieter
28001 Feb 2008 @ 07:33 PSTDatabaseReplyDropping duplicates in SQLcol1 is supposed to be unique?One of those rows should be returned?AAAA 1111 RRRR SSSSAAAA 2222 RRRR SSSSThis will return a row randomly:select col1,col2,col3,col4from tabqualify row_number() o...
27917 Jan 2008 @ 09:27 PSTUDAReplyAggregationHi Marc,it's strange, because the update is based on two columns and one of those is also used within the where-condition.What kind of summable information is hidden within that column?I simply can...

Pages