#DateForumTypeThreadPost
14120 Feb 2012 @ 12:17 PSTDatabaseReplyCreating Dynamic columns... start searching in the forum http://forums.teradata.com/forum/database/transpose-rows-to-column#comment-19132 or in www.teradataforum.com there are other posts which are dealing ...
14019 Feb 2012 @ 11:37 PSTDatabaseReplycast from decimal to float cast decimal to float shouldn't be a problem   select cast(123456789012345678 as decimal(18,0)) as dec_val,               cast(dec_val as fl...
13919 Feb 2012 @ 10:47 PSTDatabaseReplySelect number not in a column didn't run it but I guess this will work   select min(id) + 1 from ( select id, min(id) over (order by 1 rows between 1 following and 1 following) as next_id fro...
13819 Feb 2012 @ 10:15 PSTGeneralReplyPerformance comparision between two teradata DBs As said before - first check DBQL to see if resource consumption is different. If yes, stats, index choice etc. should be checked. If no - check the TSAM settings for the workload this repor...
13717 Feb 2012 @ 11:13 PSTDatabaseReplyRequire sql query for this issue. with OLAP functions (check the manual) you have access to values of different rows miN(start_dt) over (partition by POL_ID order by start_dt rows between 1 following and 1 following) Wil...
13617 Feb 2012 @ 08:13 PSTDatabaseReplyINTERVAL SUBTRACTION FROM DATE FIELD IN WHERE CLAUSE this is a nice one dieter ;-)
13517 Feb 2012 @ 08:08 PSTDatabaseReplyRequire sql query for this issue. this should do    select POL_ID,        START_DT,        end_dt,        row_number() over (partition by POL_ID...
13417 Feb 2012 @ 01:09 PSTDatabaseReplyINTERVAL SUBTRACTION FROM DATE FIELD IN WHERE CLAUSE This seems like a problem of your source data...   select count(*) from sys_calendar.calendar WHERE CURRENT_DATE < calendar_date - 14   works.   Do ...
13316 Feb 2012 @ 10:46 PSTDatabaseReplyINTERVAL SUBTRACTION FROM DATE FIELD IN WHERE CLAUSE WHERE CURRENT_DATE < PROMO_DATE - 14
13216 Feb 2012 @ 08:00 PSTToolsReplyhow can i remove the extra spaces when using bteq to export data into a flat txt file manual states  "In Field Mode, BTEQ returns all data values in character format."  And here BTEQ seems to add the extra spaces - don't see a way to overcome ...
13116 Feb 2012 @ 06:57 PSTDatabaseReplySignificance of MaxLength column Max number of bytes used to store the values
13016 Feb 2012 @ 06:55 PSTGeneralReplyWhich is better GROUP BY, DISTINCT or SET table classical answer for an unspefic question ;-> - it depends. Can you share more information on the process. How many rows, how many dups etc. Where do the dups come from? But even if y...
12916 Feb 2012 @ 04:57 PSTDatabaseReplySHOW MACRO/TABLE does not always return full DDL Do you connect with ODBC or .net? In other posts it was suggested to use .net.  
12816 Feb 2012 @ 12:15 PSTToolsReplyhow can i remove the extra spaces when using bteq to export data into a flat txt file I guess some of them related to data types - so can you share the DDL of the table?
12715 Feb 2012 @ 11:39 PSTToolsReplyCan ANSI transaction mode be set in TPT script? did you read the manuals? There are some good examples for different jobs to start with.
12615 Feb 2012 @ 05:13 PSTToolsReplyUpdate and Insert inside a CASE Do you want to use a stored procedure? So far you didn't explained what you really need to do. As VBurmist said it might be worth to check Merge syntax or check the other o...
12515 Feb 2012 @ 04:28 PSTToolsReplyUpdate and Insert inside a CASE Inserts and Updates can not be used in Case statements in plain SQL - and I quess in no DB system. So please share your table layouts and sample data which you want to processes.
12415 Feb 2012 @ 02:55 PSTDatabaseReplywhether row hash changes when new nodes or Amp added? Yes for real data type changes like char to integer. And smallint and integer values are hashed the same (for smallint range) Check the outcome of hashrow    select has...
12314 Feb 2012 @ 12:37 PSTDatabaseReplyReturning to setting variables. snippet from previous discussion does not work on current teradata platform. you might also check dieters post on global and session parameters http://developer.teradata.com/blog/dnoeth/2011/03/global-and-session-level-parameters-in-sql
12214 Feb 2012 @ 12:31 PSTDatabaseReplyJoining large data on ranged indexies By the way - how many rows contain your lookup table?
12114 Feb 2012 @ 05:09 PSTPrivate Forum
12013 Feb 2012 @ 08:30 PSTDatabaseReplyJoining large data on ranged indexies Can you share the explain of your query? Which stats are collected? just for my understanding...   all  lookup_idx between start_lookup_idx and end_looku...
11910 Feb 2012 @ 11:46 PSTDatabaseReplyUnexpected syntax error 3706 when using CASE IN with timestamp values Sorry for that - was visible in my browser after I posted it but can't see it now either. Check the SQL Reference - Functions and Operators. I searched for NOT IN and found a syntax ...
11810 Feb 2012 @ 07:59 PSTDatabaseReplyUnexpected syntax error 3706 when using CASE IN with timestamp values Hi, I was intuitvely thinking that  CASE WHEN timestamp IN (timestamp1, timestamp2, timestamp3) THEN 1 ELSE 0 END   will work only with constants and not with columns ...
11710 Feb 2012 @ 02:34 PSTPrivate Forum

Pages