#DateForumTypeThreadPost
31614 May 2012 @ 11:26 PDTAnalyticsReplyDate Function specify four digist years! There will be always confusion how it should be interpreted... Dec-12 can be Dec 2012 or 12 day of December... Never format a year with 2 digits ;->
31511 May 2012 @ 07:32 PDTPrivate Forum
31409 May 2012 @ 08:04 PDTDatabaseReplyDerived Table vs View Played arround with "WITH" syntax an seems that optimizer can not be cheated with this as well - which is good :->.  
31309 May 2012 @ 02:37 PDTDatabaseReplyDerived Table vs View   A view is "only" a logical construct for the optimizer. He will always resolve it to the base tables - also over many nesting levels. Derived tables often also be rewrit...
31203 May 2012 @ 12:32 PDTDatabaseReplyBTEQ EXPORTING a VALUE to file. I am not Jim but yes you can... export reset is important here.
31103 May 2012 @ 12:19 PDTTeradata ApplicationsReplyHow to find number of concurrent users in Teradata You would need to enable the data collection process before you can analyse historic data. Seems that this is not active in your environment. Do you log all queries in DBQL on detail level?&...
31002 May 2012 @ 04:42 PDTDatabaseReplyQUERY TUNING sorry no - locks have no impact on spool consumption. start reading the manuals.
30902 May 2012 @ 02:39 PDTDatabaseReplyAvoid prdct join So what is your issue with the product join? At the end - the explain gave you a hint to collect some more stats.  But - as you know if you join two tables both rows which need...
30802 May 2012 @ 02:29 PDTDatabaseReplyQUERY TUNING if the estimated row counts to not match it is indicating that the optimizer does not have the right infos to come up with a good plan. Missing or wrong stats. So you need to spend time to r...
30702 May 2012 @ 01:48 PDTDatabaseReplyQUERY TUNING check if the row counts in the explain match the reality.  are stats up to date? missing stats?
30602 May 2012 @ 12:59 PDTDatabaseReplyTab and new line symbols So I gues you need to be more specific on your question How can I add Tab and new line symbol to a string without using UDF? The answer is concat. What is the ascii number for LF and...
30501 May 2012 @ 11:36 PDTDatabaseReplyProblems with two views on different Databases http://www.teradataforum.com/teradata/20040908_102929.htm
30430 Apr 2012 @ 05:54 PDTDatabaseReplyTab and new line symbols Tab and new line are only charcters. So you can concat them as other chars...   select ' '!! 'text' !! ' ' !! 'new line text';  
30327 Apr 2012 @ 12:46 PDTDatabaseReplyChange all periods "." in a column to forward slash "/" As Carlos already indicated recursive could be used - but I don't have a clue how the performance looks like on bigger data volumes. This solution assumes that the max str length is 100....
30227 Apr 2012 @ 12:01 PDTDatabaseReplyError in using a Create DDL in TD 12 The quotes seem to be wrong FORMAT ‘9(5)’ need to be FORMAT '9(5)' etc.
30127 Apr 2012 @ 11:58 PDTDatabaseReplysampleid This might work for you 1. sample with replacement 200000 -> all in one 2. generate a random number for each row 3. calculate row_number based on random number sort 4. calcula...
30022 Apr 2012 @ 09:22 PDTDatabaseReplySql help. Dieter, just a minor comment - in the second SQL is the  case when ind = 1 then amt end missing...
29920 Apr 2012 @ 06:39 PDTDatabaseReplywhy this error was raised? help me! It looks like that dbapp.temp_table contains two rows for at least some Invoice_Id, Item_Nr combination check  select Invoice_Id, Item_Nr, count(*) from dbapp.temp_table ...
29820 Apr 2012 @ 12:56 PDTExtensibilityReplyUnpacking BLOB column data which is java encrypted using an UDF   It would be good to get some more infos from your side.  Which algorithm is used to encrypt the data? Is only key used for all data? Should the key be embedded in the...
29719 Apr 2012 @ 08:03 PDTDatabaseReplyError creating a view using "WITH RECURSIVE" recusive view def should start with CREATE RECURSIVE VIEW here an example from the docu...   CREATE RECURSIVE VIEW reachable_from (source,destination,depth) AS ( SELECT...
29617 Apr 2012 @ 10:37 PDTToolsReplyCopy tables between two different systems Archive and Restore should be also ok or TPT. But what is the rational behind this if you already have data mover in place?
29517 Apr 2012 @ 12:16 PDTGeneralReplyCurrent year starting month and current year ending month What do I miss here? As it will be always jan and dec you could simply select 'jan' as year_start_month, 'dec' as year_end_month;  
29416 Apr 2012 @ 08:33 PDTGeneralReplyVolatile table issue Did you try a  show your query ?
29313 Apr 2012 @ 01:14 PDTDatabaseReplyDatatype mismatch in Joining Columns The internal representation of float and integer is different.  So a plain bit comparison - and this is how it always end up - would be always false even if the values stored are the sa...
29212 Apr 2012 @ 12:21 PDTDatabaseReplySQL assistance--find mismatches in daily data I am not sure that I fully understand your model and question. From what I got I would try select * from table qualify min(ACTION_DATE) over (partition by cust_id) <= DATE_COL ...

Pages