209 | 07 Dec 2011 @ 01:42 PST | Tools | Reply | tdload: TPT Configuration File was not found |
Good!
|
208 | 07 Dec 2011 @ 12:17 PST | Tools | Reply | tdload: TPT Configuration File was not found |
Please provide me with the contents of the directory pointed to by the $TWB_ROOT environment variable on the 64-bit machine.
The file in question is probably the twbcfg.ini file.
That fi... |
207 | 07 Dec 2011 @ 11:45 PST | Tools | Reply | TPT - Problem loading delimited data with multiple files |
Did you check to make sure there is an end-of-record marker at the end of the last record of the file?
Sometimes, people forget about that when creating their data files.
You should not ... |
206 | 05 Dec 2011 @ 11:06 PST | Tools | Reply | TPT Load Operator error table being loaded? |
You would have to go to the Teradata At Your Service website, but you will probably need to provide some type of customer information.
That is not my area (I am in engineering) so you may ha... |
205 | 05 Dec 2011 @ 11:05 PST | Tools | Reply | TPT script loading issue |
Yeah, we are working to correct that.
The console is supposed to have the row counts from the error tables, and thus you would not have a value in the "duplicate row" message.
... |
204 | 05 Dec 2011 @ 10:22 PST | Tools | Reply | TPT script loading issue |
You will have to look inside the log (not just the messages on the console) to see if there is any additional information.
|
203 | 05 Dec 2011 @ 10:20 PST | Tools | Reply | TPT Load Operator error table being loaded? |
Always download the latest and greatest set of patches for the entire product.
Efix patch #7 would be 13.10.00.07.
But you need to make sure to download all patches for all packages for ... |
202 | 02 Dec 2011 @ 04:13 PST | Tools | Reply | TPT Load Operator error table being loaded? |
When a job fails prematurely, the target table remains locked. This lock is enforced by the Teradata database.
However, the problem with the restart was a bug in our code and that has been f... |
201 | 30 Nov 2011 @ 01:03 PST | Tools | Reply | Fastload DateTime, Timestamp |
What you just showed was loading timestamp data into a timestamp column.
However you cannot load data from a timestamp value into a DATE column in Teradata using FastLoad.
Teradata will ... |
200 | 28 Nov 2011 @ 10:12 PST | Tools | Reply | how to avaoid Junk values in Fast Export |
What do you mean "byte format"?
Is the "special" character the first character of the data?
If so, that is probably the row length.
|
199 | 23 Nov 2011 @ 04:49 PST | Tools | Reply | Need Help on using TPT with UNICODE characters |
Just be careful because the first 2 bytes might be in binary. The normal format that is exported includes a 2-byte row length.
|
198 | 23 Nov 2011 @ 03:25 PST | Tools | Reply | Need Help on using TPT with UNICODE characters |
The Export operator executes the FastExport protocol. That procotol returns the data in binary format, not text. Therefore, we cannot use that operator to write out delimited data, which is text... |
197 | 22 Nov 2011 @ 09:25 PST | Tools | Reply | TPT variables in script itself (Providing a default value that could then be overridden) |
Check out the SET command.
(Although I am not sure why you want to set the job variables in the script itself. It defeats the purpose of having job variables.)
Whether the job variable h... |
196 | 22 Nov 2011 @ 04:46 PST | Tools | Reply | Loading into Views using TPT |
Then I stand corrected. If the MultiLoad protocol allows views (I have always been under the impression that those 2 utilities canno load views, but if the documentation says otherwise, then so ... |
195 | 22 Nov 2011 @ 10:41 PST | Tools | Reply | Loading into Views using TPT |
The Load and Update operators do not support loading into views. That is a restriction of the FastLoad and MultiLoad protocols (from the DBS).
You can use the TPT Stream operator (similar to... |
194 | 21 Nov 2011 @ 09:28 PST | Tools | Reply | DELIMITER IN DATA |
You will need to change your delimiter character in order to process that data (seems to make sense).
If the comma is the delimiter, then we scan down the input data until we see a comma, an... |
193 | 18 Nov 2011 @ 11:32 PST | Tools | Reply | Problem using RowErrFileName |
Ok, a few things.
First, if you are reading all of those files (you used the wildcard *.csv) you should be specifying more than 1 instance of the DataConnector operator so that you can get t... |
192 | 14 Nov 2011 @ 04:28 PST | Tools | Reply | Need Help on using TPT with UNICODE characters |
There are 2 things to consider:
1. you cannot write data in delimited format by using the Export operator; you must use the Selector operator and you must set the ReportMode attribute to the... |
191 | 07 Nov 2011 @ 09:30 PST | Tools | Reply | Fastload DateTime, Timestamp |
What I see if a table with 2 columns:
create table temp
(
tempid numeric,
birthdate date
);
The data you have is not valie for a "DATE" column.
The data ... |
190 | 27 Oct 2011 @ 01:43 PDT | Tools | Reply | TPT with mainframe Varible block file |
Please see if this DevX article answers your questions.
http://developer.teradata.com/tools/articles/accessing-db2-using-the-tpt-odbc-operator-on-zos
If you still have questions, p... |
189 | 26 Oct 2011 @ 12:31 PDT | Tools | Reply | double pipe delimiter ('||') in Mload script. |
Please be more specific about your request.
|
188 | 13 Oct 2011 @ 06:53 PDT | Tools | Reply | CREATION OF ADW USING TPT AND JMS ACCESS MODULES |
Our access module API only supports access modules written in C.
|
187 | 26 Sep 2011 @ 11:15 PDT | Tools | Reply | CREATION OF ADW USING TPT AND JMS ACCESS MODULES |
Teradata does not support internal access modules. All access modules are built to be run on the client machine and called by TPT. Thus, each access module has to be customized.
However, the... |
186 | 22 Sep 2011 @ 03:43 PDT | Tools | Reply | TPT - error TET15111 exporting from Oracle to File |
Well, I have truly never seen this before, but a call to "malloc" to allocate some space (small) for a buffer, failed.
This seems to be a system resource issue. I do not know how t... |
185 | 22 Sep 2011 @ 03:37 PDT | Tools | Reply | TPT Job sits Eternally in Acquisition Phase |
Have you tried the same query from an adhoc ODBC test program, to see what (and how fast) it retrieves?
I would say right now, the only thing I can suggest is to download an evaluation copy ... |