#DateForumTypeThreadPost
1325 Jun 2013 @ 07:36 PDTToolsTopicParallel Transporter Is there a way to change the default location of the Parallel Transporter Log and CheckPoint folders. From a security standpoint the default locations are not optimal.
1222 Jul 2011 @ 06:12 PDTToolsTopicOLELoad This is a cool tool for doing quick one off loads. Can I request some modifications? 1. Not have it autoload the last file unless passed on the command line. 2. When loading if it encounters an...
1101 Sep 2010 @ 05:46 PDTToolsTopicQuestion: Is this a user only forum or is this also a way to feed back to Teradata Developers?Is this a user only forum or is this also a way to feed back to Teradata Developers? This would be a good oportunity for feedback to developers. Many of the tools being produced are fantastic id...
1001 Sep 2010 @ 05:26 PDTConnectivityReplyIssue Installing the ODBC Driver on a Windows XP laptopMight try getting a new copy of the ODBC install from the website and using it. The one you have may be currupt.
901 Sep 2010 @ 05:09 PDTToolsReplyHow to use Volatile tables in Parallel TransporterThat is what I was thinking, a bummer, but what I was thinking. Thank you for your response. Maybe one of these guys will have a work around. These are very big queries with in some cases 200+ G...
831 Aug 2010 @ 06:48 PDTToolsReplyRegarding Temporary SpaceTeradata's spool and temporary space space is perm space that is not currently being used.
731 Aug 2010 @ 06:31 PDTToolsReply bypass username and pwd in BTEQ by using LOGONPROMPT OFFTry the format .LOGON tptid/userid,password
631 Aug 2010 @ 06:23 PDTToolsReplySPOOL SPACE ISUUEOk try this turn on DIAGNOSTIC HELPSTATS then run explain on your SELECT. It should help you identify where the issue is. DIAGNOSTIC HELPSTATS ON FOR SESSION; EXPLAIN SELECT RMS.JOB_ID ...
531 Aug 2010 @ 06:06 PDTToolsReplyTPT errorI see you are using @TeradataSourceUser and @TeradataSourcePassword if these are not specified in the script then you have to pass them in a variable file. tbuildexe.exe -f -v Also the /* ...
431 Aug 2010 @ 05:41 PDTToolsReplyTPT errorThe output of this should have given a jobid if it got that far. If it did you can use TLOGVIEW to view the job log and see more of a result set.
331 Aug 2010 @ 04:17 PDTToolsTopicHow to use Volatile tables in Parallel TransporterI have SQL that needs to run some preprocessing creating a volatile table to be exported to a file. If I use a setup step TPT is using a different session for each step and the volatile table goes ...
231 Aug 2010 @ 04:13 PDTToolsTopicParallel Transporter uses more spool than other types of sessions.Any idea why TPT is using more spool than the same query in other tools such a SQL Assistiant?
102 Jul 2007 @ 09:58 PDTToolsReplyWant to know about OLE_LOAD tool...its urgentThe tool interfaces the FastExport/FastImport and MultiLoad tools to Windows OLE. This will let you for example perform a FastLoad from Microsoft Access to Teradata and back. One side of the load m...