303 | 11 Mar 2008 @ 03:49 PDT | Database | Reply | vinay_144@hotmail.com | It's always the same way using any kind of connection:call myproc(myparam);Dieter |
302 | 11 Mar 2008 @ 03:48 PDT | Database | Reply | TASM Information | What 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... |
301 | 11 Mar 2008 @ 03:41 PDT | Tools | Reply | No More spoolspace error | Hi Rajiv,it's three tables, but only one join condition join -> cross joinDieter |
300 | 07 Mar 2008 @ 07:19 PST | Analytics | Reply | Convert Text to Proper Case is huge problme | Less dirty:install the availabe Oracle UDF library and simply run.select initcap(cityname)from tabDieter |
299 | 07 Mar 2008 @ 07:19 PST | Analytics | Reply | Convert Text to Proper Case is huge problme | Less dirty:install the availabe Oracle UDF library and simply run.select initcap(cityname)from tab |
298 | 07 Mar 2008 @ 07:14 PST | Database | Reply | SQL Question | Hi 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... |
297 | 07 Mar 2008 @ 07:09 PST | Database | Reply | Finding Continuos Span | Hi 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... |
296 | 23 Feb 2008 @ 10:06 PST | Database | Reply | How 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... |
295 | 23 Feb 2008 @ 10:01 PST | Database | Reply | Partitioning 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... |
294 | 22 Feb 2008 @ 04:44 PST | Database | Reply | How to declear Macro Variable? | You simply missed the final semicolon before the closing bracket:and PRDCT_TYP_CDE=:prod;);Dieter |
293 | 22 Feb 2008 @ 03:07 PST | Database | Reply | How 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 |
292 | 22 Feb 2008 @ 12:36 PST | Database | Reply | How 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... |
291 | 22 Feb 2008 @ 12:32 PST | Database | Reply | Use Declare keyword in trigger | You 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... |
290 | 22 Feb 2008 @ 12:26 PST | Database | Reply | INDENTIFY GLOBAL TEMPORARY TABLES | Hi 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... |
289 | 22 Feb 2008 @ 12:20 PST | Database | Reply | Difference between Perm / Spool / Temporary Space | The 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... |
288 | 22 Feb 2008 @ 12:15 PST | Database | Reply | LT,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... |
287 | 22 Feb 2008 @ 12:07 PST | UDA | Reply | How 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 |
286 | 22 Feb 2008 @ 11:59 PST | UDA | Reply | Notify Exit Routine | The 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" ... |
285 | 22 Feb 2008 @ 11:49 PST | UDA | Reply | Space management in Teradata | There'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... |
284 | 22 Feb 2008 @ 11:39 PST | UDA | Reply | Stop 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... |
283 | 22 Feb 2008 @ 11:33 PST | UDA | Reply | EXISTS vs. IN | In 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... |
282 | 02 Feb 2008 @ 09:30 PST | UDA | Reply | SQL query to Teradata SQL | Hi 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... |
281 | 01 Feb 2008 @ 07:35 PST | Database | Reply | ranking 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 |
280 | 01 Feb 2008 @ 07:33 PST | Database | Reply | Dropping duplicates in SQL | col1 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... |
279 | 17 Jan 2008 @ 09:27 PST | UDA | Reply | Aggregation | Hi 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... |