#DateForumTypeThreadPost
6107 Mar 2016 @ 11:13 PSTDatabaseReplyDateAdd and DateDiff function in Teradata??Thanks Dieter, I think I can keep it under 10000 days. why the 10000 day limit? is is because of the DAY(4) ?? br Peter Schwennesen
6007 Mar 2016 @ 05:13 PSTDatabaseTopicDateAdd and DateDiff function in Teradata??On SQL Server you can do something like DateAdd(ms, DateDiff(ms, date1, date2), date1)/2 To get the mid date between two date 2016-02-03 12:00:00 and 2016-02-03 14:00:00, you should get the result...
5919 Nov 2015 @ 02:42 PSTDatabaseReplyView on View problemNow we hade another example her in the produktion, where it looks like it is the same problem. A joined Index was used when looking trough 1 view but not when looking trough 2.
5820 Oct 2015 @ 05:49 PDTDatabaseTopicView on View problemWe are using Views rather much. Data flows from tables trough several Views before they are used. To simplify: I have the following construct (the actual table and views are much more complicated...
5722 Jul 2015 @ 10:39 PDTDatabaseReplyRPAD and LPAD gives: SELECT Failed [9804] Response Row size or Constant Row size Hi Dieter Thanks, I do not understand the internals of the LPAD and RPAD. Its defined that the max output length is 2, even then it returns a VARCHAR(32000) strange. Hovere this works now: DRO...
5622 Jul 2015 @ 02:04 PDTDatabaseReplyRPAD and LPAD gives: SELECT Failed [9804] Response Row size or Constant Row size Its looks like there is a similar problem with STRTOK DROP TABLE T2; CREATE MULTISET VOLATILE TABLE t2 (Str VARCHAR(30)) ON COMMIT PRESERVE ROWS; DELETE FROM T2; INSERT INTO T2 VALUES ('1,...
5521 Jul 2015 @ 02:04 PDTDatabaseTopicRPAD and LPAD gives: SELECT Failed [9804] Response Row size or Constant Row size Is it not possible to use RPAD and LPAD more than 2 times in the same QUERY? It cannot be right. This small example gives error when running it: DROP TABLE t1; CREATE MULTISET TABLE t1 (h INT,...
5421 Oct 2014 @ 10:09 PDTToolsReplyTeradata Administrator References and ProceduresHi Dieter Thanks. br Peter Schwennesen
5321 Oct 2014 @ 01:38 PDTToolsTopicTeradata Administrator References and ProceduresWhen inside Teradata Administrator it is possible to right click on an object and select “References”, to get a list of object where it is used. We are doing some cleanup in the databa...
5208 Oct 2014 @ 12:59 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingHi Dieter I expect that it will be in a TTU? But the download page says that it is version 15.00 Where do I get the version15.0.0.3? Peter Schwennesen   Teradata Tools and Utiliti...
5107 Oct 2014 @ 03:25 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingI tried all of: DROP STATISTICS ON T1; DROP STATISTICS COLUMN VAL ON T1; DROP STATISTICS COLUMN (VAL) ON T1; all with same result: Query is invalid This is when I do it in Teradata SQL Ass...
5006 Oct 2014 @ 10:07 PDTDatabaseReplyDBC VIEWs trim to length 30 on Teradata 14ok. Thansk Peter Schwennesen
4906 Oct 2014 @ 10:05 PDTDatabaseReplyTeradata SQL Assistant 15.00 DROP STATISTICS not workingOk, The new syntax works too. But I cannot find any new syntax for: DROP STATISTICS T1; Peter Schwennesen
4806 Oct 2014 @ 03:35 PDTDatabaseTopicDBC VIEWs trim to length 30 on Teradata 14I do not understand why the VIEWS found in DBC are trimming DatabaseName, TableName and ColumnName to length 30 when Teradata 14 are capable of handling object names up to 127? Br Peter Schwennes...
4706 Oct 2014 @ 01:32 PDTDatabaseTopicTeradata SQL Assistant 15.00 DROP STATISTICS not workingWe cannot drop statistics with the syntax we normally use, when using the new SQL Assistant 15.00. We have tried logging on both with ODBC, with several changes in the setup and with Teradata logo...
4621 Aug 2014 @ 12:34 PDTToolsTopicBug in SQL Assistant 15.00I think you have introduced a bug in SQL Assistant 15.00, changes I am making to the setup are not maintained after a restart. The (CTRL+D) to toggle the comment on/off are not predefined. Therefo...
4520 Aug 2014 @ 01:09 PDTToolsTopicSQL Assistant v.15.00 Keyboard Shortcut problems - CommentI just installed the new TTU 15.00 SQL Assistant, but I having problems with the keyboard shortcuts. In previous versions the (CTRL + D) turned text to and from comments. If no text selected then t...
4420 Aug 2014 @ 01:09 PDTToolsTopicSQL Assistant v.15.00 Keyboard Shortcut problems - CommentI just installed the new TTU 15.00 SQL Assistant, but I having problems with the keyboard shortcuts. In previous versions the (CTRL + D) turned text to and from comments. If no text selected then t...
4315 Aug 2014 @ 04:32 PDTDatabaseReplyREGEXP_REPLACE HELP String fist letter uppercase rest lowercase!Hi Raja The intcap function is super. Are there other function slike this new in 14? Peter Schwennesen
4215 Aug 2014 @ 01:09 PDTDatabaseTopicREGEXP_REPLACE HELP String fist letter uppercase rest lowercase!I need to convert all words in a string to first letter uppercase rest lowercase, while skipping some specific words, and remove multiple spaces. I like to convert: “ teST   is a T...
4123 Jul 2014 @ 02:19 PDTDatabaseReplyGroup by on a Group by not working as expected!!!Hi Dieter We are going to 14.xx in near future. I tried logging into the new machine and here all queries returned the same correct result. It must be a bug in 13.10 then. I do not think my DBA wi...
4023 Jul 2014 @ 01:53 PDTDatabaseReplyGroup by on a Group by not working as expected!!!Hi Dieder OK. But do you think this is a bug? Should all above give the same result? I was afraid that I made some wrong assumptions in the code? Peter
3922 Jul 2014 @ 11:03 PDTDatabaseReplyGroup by on a Group by not working as expected!!!Hi Dieter I do not get any errors. The queries just return a result set. I expected all 3 examples to return only 2 rows with the average number of sum pr day. What I do not understand is that wh...
3817 Jul 2014 @ 05:52 PDTDatabaseReplyGroup by on a Group by not working as expected!!!Maybe it something with the EXTRACT function?? This WORKS: SELECT Y, AVG(V) AS V FROM ( SELECT SUBSTR(D,1,4) AS Y, SUM(V) AS V FROM T1 GROUP BY D ) AS x...
3717 Jul 2014 @ 05:46 PDTDatabaseReplyGroup by on a Group by not working as expected!!!Comment, this is just a test script, not something in production. Therefore the short names of V, D, Y. Peter

Pages