#DateForumTypeThreadPost
930 Mar 2016 @ 10:55 PDTExtensibilityReplyOracle TruncDate UDF - cannot compile truncdate2For the timestamp issue, DR 181569 has been created for an RFC.  No info yet on when this will be fixed.
823 Mar 2016 @ 02:45 PDTExtensibilityReplyOracle TruncDate UDF - cannot compile truncdate2Final, final update:  I also found the ISO year functionality does not seem to be working correctly in the "Oracle" UDF (at least according to what I have learned about ISO year).&nb...
723 Mar 2016 @ 02:39 PDTExtensibilityReplyOracle TruncDate UDF - cannot compile truncdate2Thanks.  I will pursue the timestamp issue with GSC.
623 Mar 2016 @ 02:27 PDTExtensibilityReplyOracle TruncDate UDF - cannot compile truncdate2Final update:  after I dropped all of the other trunc* functions, the SEL TRUNC(DATE),'MM'; query does run successfully.  Based on the documentation for the Oracle trunc UDF, the ...
523 Mar 2016 @ 12:53 PDTExtensibilityReplyOracle TruncDate UDF - cannot compile truncdate2Carlos, I think you are correct about the compiler.  The last time we compiled these was back in 2008 and 2009.  I am learning more about C right now.  I think I have identified the ...
422 Mar 2016 @ 04:56 PDTExtensibilityTopicOracle TruncDate UDF - cannot compile truncdate2We have had the Oracle UDFs installed for a number of years.  But we had an issue with our 15.10 database upgrade and SYSLIB had to be dropped and recreated.  This meant we had to reinsta...
303 Sep 2015 @ 02:25 PDTJobsTopicSr. Teradata DBA FTE position at Nike, Inc.Are you interested in working at Nike as an FTE?  We are looking for a senior-level Teradata DBA, with a strong background in performance tuning, TASM, Viewpoint, and Linux.  See the comp...
206 Jul 2009 @ 05:30 PDTToolsReplyPerformance TuningThis is a huge topic that cannot be answered quickly. There are several Orange Books and Teradata classes that will help. Some of the Orange Books include topics on indexes (PPI and non-PPI), Tun...
106 Jul 2009 @ 05:01 PDTToolsReplyWDID in tables?Try looking at WlcName in TDWM.WlcDefs.