76 | 13 Jan 2016 @ 12:37 PST | Tools | Easy Loader for Teradata Parallel Transporter | Try specifying "X*.txt".
Error tables are stored on the database, most likely in the same database as your target table.
|
75 | 06 Jan 2016 @ 11:28 PST | Tools | Easy Loader for Teradata Parallel Transporter | Some of these answers depend on the version od TPT that you have installed.
tdload can support multiple files to load into a single table. You must use wildcard syntax for the file name in... |
74 | 10 Jul 2015 @ 01:57 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | In 13.10, we did not support quoted delimited data.
Thus, the field in question:
|"lot"most^who=mother|concern|XYZ
would have loaded with the quote characters included ... |
73 | 10 Jul 2015 @ 09:39 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | Ok, so this is a regression.
If you do not mind, please send me the tdload command, the DDL of the target table and an entire row of data (a row that fails) so that I can work on this inhouse.
Wh... |
72 | 09 Jul 2015 @ 04:56 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | The error message indicated column 6.
Was the data you provided the actual entire record?
Or did you remove some of the data (with or without quotes, I do not see at least 6 columns).
I am askin... |
71 | 24 Apr 2015 @ 04:42 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | Please send me the .out log file to my email:
steven.feinholz@teradata.com
|
70 | 24 Apr 2015 @ 03:06 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | Ok, this is inconsistent with the presented problem.
You stated, "Data is pipe delimited".
If the data is pipe delimited, then you do not need to provide a delimiter character, ... |
69 | 24 Apr 2015 @ 02:36 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | Why are you specifying the delimiter as a hex value.
Please just use the Delimiter attribute and set it to '|'.
|
68 | 24 Apr 2015 @ 12:49 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | I will have this looked into. A few notes:
1. please provide the version of TPT you are using.
2. Although not harmful, you are putting in attributes and values that do not pertain to the operato... |
67 | 08 Apr 2015 @ 06:28 PDT | Tools | Easy Loader for Teradata Parallel Transporter | Please send this request to the proper forum.
http://forums.teradata.com/forum/tools
|
66 | 16 Jan 2015 @ 02:40 PST | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | I cannot assist on any syntax errors unless you include the entire script.
|
65 | 11 Jun 2013 @ 04:35 PDT | Tools | Easy Loader for Teradata Parallel Transporter | Right now, the user cannot tell tdload which operator to use. We are aware of this type of enhancement and will consider it in a future release.
The idea behind tdload is to remove the user from m... |
64 | 17 Apr 2013 @ 12:06 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | 1. We will always prefer that you use TPT. TPT is the load/unload tool moving forward.
2. TPT. TPT is the only load/unload application that can load multiple files in parallel.
|
63 | 11 Feb 2013 @ 12:07 PST | Tools | Easy Loader for Teradata Parallel Transporter | Please provide me with the command line you are submitting, and the contents of the job variable file. |
62 | 17 Oct 2012 @ 06:44 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | Most likely, no. Although we would like to get there some day, it is very difficult for TPT to know what the user wants to do, the size of the data, the source of the data, the speed of the network... |
61 | 17 Oct 2012 @ 06:28 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | Potentially, depending on your environment (speed of the database, throughput of the network, size of the job).
You will have to experiment and see what works best for you for that job.
We output... |
60 | 17 Oct 2012 @ 12:46 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | Yes. |
59 | 17 Oct 2012 @ 11:07 PDT | Tools | Use Teradata Parallel Transporter to Move Data Without Landing the Data to Disk | 1. In most cases (unless you have a very slow network between the client server and Teradata, or your Teradata system is really slow), 2 instances of the Update operator should be enough. (In fact,... |
58 | 08 Oct 2012 @ 06:02 PDT | Tools | Easy Loader for Teradata Parallel Transporter | got_boys_123: did you try enclosing $L$DEV0 in double-quotes? Also, on Unix, try to put a backslash ("\") in front of the "$" characters. The reason for the failure is that the Unix shell is proces... |
57 | 08 Oct 2012 @ 05:27 PDT | Tools | Easy Loader for Teradata Parallel Transporter | Babugandi: in TPT14.0 we introduced the support for quoted delimited strings. The 14.0 documentation will provide the details.
|
56 | 14 Sep 2012 @ 02:17 PDT | Tools | Easy Loader for Teradata Parallel Transporter | No, that option is not currently available with Easy Loader. |
55 | 13 Sep 2012 @ 05:43 PDT | Tools | Easy Loader for Teradata Parallel Transporter | Well, that is true about a lot of the postings on this page, but so far we have not enforced rules as to how/what/where people can post their questions. Yes, it would be nice for people to only pos... |
54 | 13 Sep 2012 @ 11:21 PDT | Tools | Easy Loader for Teradata Parallel Transporter | TPT does not use the Teradata JDBC driver.
TPT has no JDBC integration.
|
53 | 24 Aug 2012 @ 03:35 PDT | Tools | Easy Loader for Teradata Parallel Transporter | Not yet. They will be available in TTU 14.10. |
52 | 08 Aug 2012 @ 02:55 PDT | Tools | Teradata Parallel Transporter Supports Quoted VARTEXT in TTU14.00 | The support of embedded characters that match the closing quote mark was not implemented in the initial "quoted VARTEXT feature. We are working on that in 14.10. However, when you do this:
"Good... |