#DateForumTypeThreadPost
1528 Mar 2016 @ 08:41 PDTDatabaseReplyPerformance of the We do a MERGE into table HUB_ENCOUNTER_MESSAGE from Spool 18767. step of an insertThank you all for bringing this issue to our attention.  We regard this as a bug and have created a JIRA for its repair. The excellent performance is seen due to fastpath insert - the databas...
1403 Mar 2015 @ 04:18 PSTCloud ComputingReplyVM Express GDO file isf.gdo is corrupted(?)We live in a global economy so shipping is not a problem.  But, rumor has it that there is good beer in Munich so shipping may not be necessary.  Do they have a beer equivalent for Starbu...
1302 Mar 2015 @ 10:22 PSTCloud ComputingReplyVM Express GDO file isf.gdo is corrupted(?)Thanks Dieter!  I can verify that deleting the file and restarting PDE as you suggested did the trick.  Whew!  I've been using these VM's since they were released on all vers...
1201 Mar 2015 @ 06:00 PSTCloud ComputingTopicVM Express GDO file isf.gdo is corrupted(?) PDE won't start according to /var/log/messages due to GDO being unable to synch.     INFO: Teradata: 11458 #Event number 33-11458-00 (severity 10, category 12) GDO file isf...
1101 Mar 2015 @ 05:56 PSTCloud ComputingReplyVMWare Workstation 11 shared folders not working Years ago I used shared folders in the VM, but have abandoned them after some issue like you're facing. Instead I use this simple ftp server app:  http://www.sentex.net/~mwandel/ftpdmin...
1021 Aug 2014 @ 01:43 PDTDatabaseReplyTIMESTAMP(6) WITH TIME ZONE, space between seconds and timezone, need to remove itThanks Dieter!     The format string that supports the Timestamp(6) with a Blank (the equivalent to TO_TIMESTAMP_TZ)  is this: CAST('1985-09-12 13:20:53.641234 +03:00' A...
920 Aug 2014 @ 04:51 PDTDatabaseReplyTIMESTAMP(6) WITH TIME ZONE, space between seconds and timezone, need to remove itThe loss of precision made the substring route a non-starter. The documentation for TO_TIMESTAMP_TZ shows the format string that would have done the trick: (FORMAT 'YYYY-MM-DD HH24:MI:SS.FF6 ...
820 Aug 2014 @ 02:14 PDTDatabaseReplyTIMESTAMP(6) WITH TIME ZONE, space between seconds and timezone, need to remove itDieter, thanks for all of your wonderful posts on this site.  You're truly a rock star. I agree wholeheartedly that this is complicated, but I have the same question as the OP.  For ...
729 Aug 2012 @ 10:09 PDTToolsReplyText Qualifiers in Teradata Utilities Why not upgrade to TPT 14 to get the benefit of this feature?  This is a supported option by GSC and also decomposes the tasks of upgrading to the next version of the database.  I.e., ...
614 Jun 2012 @ 10:56 PDTDatabaseReplyQueue Tables in Database Express Or use the .Net provider instead of ODBC in SQL Assistant.  It works perfectly there.
518 Oct 2011 @ 07:28 PDTToolsReplyTeradata Parallel Transporter Wizard 13.10 Issues There are several coding errors in the Wizard that need to be fixed for it to work.  I just uninstalled 13.10 for 14.0 and my tweaked version was removed in the uninstall or I'd post it.
430 Sep 2011 @ 09:26 PDTCloud ComputingTopicSUSE Date/Time & Teradata-ntp I'm running on a Windows 7 64bit host with an i7 processor for the SUSE 10.1 VMWare guest running TD Express. For reasons that are beyond my interest the guest has horrible tim...
304 Aug 2011 @ 09:51 PDTDatabaseTopicIs there a "reserved words" table/view?I've looked through DBC and can't find one. I'd rather not have to maintain my own table containing Reserved and new Non-Reserved words by DBS version.
204 Aug 2011 @ 09:48 PDTDatabaseReplyDuplicate Primary Key errorThe SQL Data Definition Language Detailed Topics manual describes this issue in detail. See page 469 in the 13.10 documentation. You may want to consider "no cycle" in your definition of the U...
105 Jun 2011 @ 12:21 PDTToolsReplyTPT script loading issueI am seeing the exact same issue. The table does not have a UPI or USI defined on it and the UV error table is empty after the load. How can there be *Possible* Duplicate Rows on a table withou...