#DateForumTypeThreadPost
701 Aug 2016 @ 03:07 PDTToolsReplyMLOAD APPLY WHERE condition which is not an equalityIt turns out that there was a second IMPORT statement involved here.  I had to add a "superfluous" condition on that IMPORT to get the behavior I expected to see with the IMPORT comm...
601 Aug 2016 @ 08:35 PDTToolsTopicMLOAD APPLY WHERE condition which is not an equalityI have a very simple working MLOAD and have a new requirement to block data from being INSERTED.  I see many examples where the WHERE of an APPLY statement is specified as equality (=) and am ...
522 Jul 2014 @ 11:57 PDTToolsReplyTPT log file locationTurns out to be user error.  I had two tbuild executions and was comparing the invocation of one with the error of another.
422 Jul 2014 @ 07:56 PDTToolsTopicTPT log file locationI've been running TPT on one (SLES-based) server for quite some time.  I decided to move some existing (running) scripts to a new (SLES-based) server, but TPT fails with: Teradata Paral...
305 Feb 2014 @ 08:36 PSTToolsReplyTeradata Parallel Transporter ~ OPERATOR FILE_WRITER ~ escape characters in output Is the only way to escape the EscapeTextDelimiter itself in the output data, to wrap REPLACE UDF's around all the CHAR/VARCHAR(x) columns and substitute "EscapeTextDelimiter concatenated w...
205 Feb 2014 @ 08:19 PSTToolsTopicTeradata Parallel Transporter ~ OPERATOR FILE_WRITER ~ escape characters in output I needed to unload data from Teradata and escape certain characters.  For example some character strings contain a pipe symbol ('|') but I am using the pipe as my delimiter.  ...
122 Nov 2011 @ 07:18 PSTToolsTopicTPT variables in script itself (Providing a default value that could then be overridden) I want to specify a default value for a variable (@TargetDatabase in my upcoming example) in the TPT script itself and then be able to override it via the command line or the job variables file&...