#DateForumTypeThreadPost
423 Apr 2015 @ 05:20 PDTDatabaseReply3706 syntax errorI suppose you get the error when you run with Bteq script. The reason is you have used the wrong syntax of substring. In Bteq: substring (string_value FROM 1 FOR 256 ))  or substr (string_va...
317 Apr 2015 @ 01:42 PDTDatabaseTopicDoes exist Teradata project standard & guideline ?Does any one create or define such standard and guideline for Teradata project (eg. naming convention, coding rule, should and shouldn't etc). In other databases like Oracle and SQL Server it i...
218 Mar 2015 @ 01:17 PDTDatabaseReplyTeradata decimal calculation behaviourHi Dieter, Thanks for the prompt answer. If we first multiply, there will be case that the numeric overflow may happen, so in some case division first could help. Unfortunately, it give the diffe...
117 Mar 2015 @ 07:56 PDTDatabaseTopicTeradata decimal calculation behaviourI have the following 2 select statements, which produce 2 different results although they should return the same result 1) sel 1045259.3800 / 3155500.0000 * 3155500.0000 returns 1.045.417,150000...