#DateForumTypeThreadPost
24113 Mar 2012 @ 12:41 PDTDatabaseReplyHandler for SQLException does not execute on SQL exception I get T7547 as SQLCODE... CREATE SET TABLE SP_LOG ( LOG_TYPE VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC, TARGET_TABLE VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIF...
24013 Mar 2012 @ 11:23 PDTDatabaseReplyHandler for SQLException does not execute on SQL exception you might consider the documentation: Structure of SQLSTATE SQLSTATE is a five-character string value divided logically into a two-character class and a three-character subclass. &ldqu...
23913 Mar 2012 @ 08:03 PDTDatabaseReplyDatatype of a Column of a View I used the same approach for create table, store column info in table drop table. so generate the statements and call the generated script. Seems to run much faster.
23813 Mar 2012 @ 06:21 PDTDatabaseReplyDatatype of a Column of a View this might take a while to run but it is only one script and does not need to create and drop tables. I used a volatile table for demo purposes only but you might want a permanent one.... ...
23713 Mar 2012 @ 05:00 PDTDatabaseReplyDatatype of a Column of a View a Stored Procedure might help - but agree that it is not ideal
23613 Mar 2012 @ 03:36 PDTGeneralReplyError 3149 "There is not much change in explain plan." So same steps and order in both? Can it be related to bigger estimated spool files?  Can you check the explain output.
23513 Mar 2012 @ 01:59 PDTGeneralReplyError 3149 Did the plan itself changed? Or only the estimates? What did you select before? Select *?  
23413 Mar 2012 @ 12:04 PDTGeneralReplyError 3149   From the documentation:   Explanation: This error occurs if a query request is aborted by Teradata TDWM for a Filter rule violation. Check currently active Terada...
23312 Mar 2012 @ 11:58 PDTDatabaseReplyDatatype of a Column of a View Maybe the following would be an alternative 1. create a tmp table with no data from the view. create table v_tmp as (select * from yourView) with no data. 2. retrieve the column type...
23212 Mar 2012 @ 11:10 PDTDatabaseReplyDatatype of a Column of a View Why can't you select all column types in one select? something like select top 1 type(col1),type(col2),...,type(coln) from view But even this is not realy elegant...
23112 Mar 2012 @ 04:58 PDTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data file you missed two ; at the end of the script... it should be   end loading; logoff;  
23012 Mar 2012 @ 03:20 PDTDatabaseReplyTimestamp Difference in Minutes (without using Periods) Nothing wrong with your code. Just for the record - will work with intervall as well and might be more intuitive to read. But will only for if the difference is less than 27.x years. &nb...
22912 Mar 2012 @ 02:55 PDTAnalyticsReplyTo find record counts for all tables in a particular database @Stefans If I compare the select count(*) from bigtable    Explanation 1) First, we lock a distinct xxx."pseudo table" for read on a RowHash to prevent glob...
22812 Mar 2012 @ 02:38 PDTDatabaseReplyWith recursive in a Select I guess the thing is to move the with recusive at the top and use it as "normal" table in the select afterwards. It is a pre definition - so something like  With recursive ...
22712 Mar 2012 @ 12:53 PDTAnalyticsReplyTo find record counts for all tables in a particular database @Stefans: Can you explain your statement that "sel 1 will be comparitively faster"? Count(*) or count(1) on wholes tables had been improved a lot since it does cylinder index ...
22612 Mar 2012 @ 12:30 PDTDatabaseReplyPeriod-to-Date Values without CTE or Subquery   Why do not simply join directly? select sum(case when sales.cal_dt between cal.week_beg_dt and cal.week_end_dt then ssa.gmv_usd_amt end) as WTD, sum(case when sales.cal_dt betwee...
22511 Mar 2012 @ 01:27 PDTDatabaseReplyWith recursive in a Select How about defining a recursive view? At least the query should be easier to read - where I don't be able to test it. REPLACE Recursive VIEW T0202_Temp (Starting_Product_Group_Id ...
22411 Mar 2012 @ 12:17 PDTDatabaseReplyNUSI space utilization In 13.10 Database Design documentation it is the section 'NUSI Sizing Equation' and 'NUSI Space Considerations' in 'Chapter 15: Database-Level Capacity Planning Consideration...
22310 Mar 2012 @ 12:24 PSTDatabaseReplyCalculate business days hours between two Timestamp(6) fields Funny request - "please send me the modified query". Please donate some money to Unicef!   Did you check the SQL at all? The first sys_calendar.reference would represe...
22209 Mar 2012 @ 06:24 PSTDatabaseReplyHandler for SQLException does not execute on SQL exception Remi was right and this is ugly to debug :-) The SQLSTATE is a char so you need to give some more ''... with '''||MySQLSTATE||''', it should do.
22109 Mar 2012 @ 04:48 PSTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data file can you share the whole log of the fastload run?
22009 Mar 2012 @ 02:08 PSTToolsReplyFastload error :when trying to load data using fastload from BTEQ exported data file This was a warining - not an error. So had all rows been loaded correctly into the table?
21908 Mar 2012 @ 10:23 PSTAnalyticsReplyNeed help with adding an integer column to a date column in teradata sorry Intervall was not the point. What is the biggest date in your order_date column? If it is  '12/31/9999' then it is the max possible date in TD. If you try to add 1 to ...
21808 Mar 2012 @ 12:25 PSTAnalyticsReplyNeed help with adding an integer column to a date column in teradata Is it possible that order_date contains some high values? Check Dieters comment in http://forums.teradata.com/forum/database/interval-subtraction-from-date-field-in-where-clause#comment-19318
21708 Mar 2012 @ 03:05 PSTDatabaseReplyHandler for SQLException does not execute on SQL exception How about sharing your code?

Pages