#DateForumTypeThreadPost
20907 Dec 2011 @ 01:42 PSTToolsReplytdload: TPT Configuration File was not found Good!
20807 Dec 2011 @ 12:17 PSTToolsReplytdload: 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...
20707 Dec 2011 @ 11:45 PSTToolsReplyTPT - 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 ...
20605 Dec 2011 @ 11:06 PSTToolsReplyTPT 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...
20505 Dec 2011 @ 11:05 PSTToolsReplyTPT 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. ...
20405 Dec 2011 @ 10:22 PSTToolsReplyTPT 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.
20305 Dec 2011 @ 10:20 PSTToolsReplyTPT 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 ...
20202 Dec 2011 @ 04:13 PSTToolsReplyTPT 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...
20130 Nov 2011 @ 01:03 PSTToolsReplyFastload 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 ...
20028 Nov 2011 @ 10:12 PSTToolsReplyhow 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.  
19923 Nov 2011 @ 04:49 PSTToolsReplyNeed 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.  
19823 Nov 2011 @ 03:25 PSTToolsReplyNeed 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...
19722 Nov 2011 @ 09:25 PSTToolsReplyTPT 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...
19622 Nov 2011 @ 04:46 PSTToolsReplyLoading 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 ...
19522 Nov 2011 @ 10:41 PSTToolsReplyLoading 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...
19421 Nov 2011 @ 09:28 PSTToolsReplyDELIMITER 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...
19318 Nov 2011 @ 11:32 PSTToolsReplyProblem 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...
19214 Nov 2011 @ 04:28 PSTToolsReplyNeed 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...
19107 Nov 2011 @ 09:30 PSTToolsReplyFastload 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 ...
19027 Oct 2011 @ 01:43 PDTToolsReplyTPT 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...
18926 Oct 2011 @ 12:31 PDTToolsReplydouble pipe delimiter ('||') in Mload script. Please be more specific about your request.
18813 Oct 2011 @ 06:53 PDTToolsReplyCREATION OF ADW USING TPT AND JMS ACCESS MODULES Our access module API only supports access modules written in C.
18726 Sep 2011 @ 11:15 PDTToolsReplyCREATION 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...
18622 Sep 2011 @ 03:43 PDTToolsReplyTPT - 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...
18522 Sep 2011 @ 03:37 PDTToolsReplyTPT 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 ...

Pages