#DateForumTypeThreadPost
50930 Oct 2013 @ 11:08 PDTToolsReplyLoading a timestamp column with Fastload#1 is the corect solution (from a Teradata SQL point of view).   But you are embedding single quotes within single quotes, and so you need to escape the single quotes for the format statemen...
50830 Oct 2013 @ 09:59 PDTToolsReplyTPT multiple instances using mainframe host (Syntax error).Looks like you have run out of system resources (most likely, shared memory). You can increase the shared memory by:   In the JCL STEP, they should have the following specification:  ...
50728 Oct 2013 @ 05:10 PDTToolsReplyTPT job fails in 14.10 but passes in 13.10Looks like this fix appears in efix #10 for 14.0 (14.00.00.10), and efix #3 for 14.10 (14.10.00.03).   Please check the patch server to see if those efixes are present.  
50628 Oct 2013 @ 09:13 PDTToolsReplyMulti load through java application.The standalone MultiLoad utility absolutely supports CSV files.  
50528 Oct 2013 @ 09:04 PDTToolsReplyTeradata Parallel Transporter Wizard 14.10 IssueThis might be difficult, but try running with JRE 1.5. The Wizard does not support 1.6 or 1.7.  
50428 Oct 2013 @ 09:03 PDTToolsReplyTPT job fails in 14.10 but passes in 13.10This issue is a known issue and has been fixed. However, the fix has not yet been backported to 14.10.  
50315 Oct 2013 @ 10:10 PDTToolsReplywaht is Spoolmode option in TPT script?Since the original question was, "What is the SpoolMode option in TPT script?" and we would rather customer use TPT over the legacy utilities, the correct answer is:   There is an ...
50214 Oct 2013 @ 01:19 PDTToolsReplyTPT Loading multiple files into a single table.The DataConnector operator supports a feature called "AcceptMissingColumns". If a record has fewer fields than the schema, it will add the missing columns, and will NULL them. (We also s...
50114 Oct 2013 @ 01:14 PDTToolsReplyUsing name of Flat File in TPT Load Have you installed the 32-bit ODBC drivers from DataDirect?  
50014 Oct 2013 @ 01:11 PDTToolsReplyTPT 14.10 64bitTPT is a 32-bit application. We have not yet released a 64-bit version of TPT.  
49925 Sep 2013 @ 05:43 PDTToolsReplyMload delete task - where does the 1 row from source be storedIn the .IMPORT command you specify the file name after the "INFILE" keyword.
49825 Sep 2013 @ 05:41 PDTToolsReplyFile Name Based up on the cloumn data.You are asking for a tool that will create the file name based on some criteria we do not see until we actually start exporting the data. That is not usually how our tools work. We need to know t...
49725 Sep 2013 @ 10:53 PDTToolsReplyMload application phase - effect of dropped restart log tableI see that you are posting several questions on utility/DBS restarts. Please refer to the utility documentation. The restart log table will keep track of what phase the job was in. During the acq...
49625 Sep 2013 @ 10:50 PDTToolsReplyusage of check point in fastloadThe restart table is for ALL restarts, both DBS and client. If the DBS restarts, all sessions are disconnected. Thus, the client utility must go through its restart logic to connect new sessions, ...
49519 Sep 2013 @ 11:44 PDTToolsReplyTPT_INFRA: TPT04101: Warning: TMSM failed to initializeThe warning message cannot be removed. It is there for a reason. It is an indication that the user has not set up TMSM support on the client box. Thus, data that would normally be sent to TMSM w...
49419 Sep 2013 @ 11:41 PDTToolsReplyMload application phase - effect of dropped restart log tableIt is possible that the job will not run because the job will be out of sync. That is how it is supposed to work. MultiLoad will get an indication from Teradata that the job is a restarted job. ...
49318 Sep 2013 @ 11:44 PDTToolsReplyusage of check point in fastloadWhat do you mean by "completed"? And what do you mean by "restart"?
49212 Sep 2013 @ 06:01 PDTToolsReplyTPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11And the efix numbers do not have to match between the different packages.  
49112 Sep 2013 @ 06:00 PDTToolsReplyTPT_INFRA: TPT01036: Error: Task (TaskID: 5, Task Name: SELECT_2[0001]) terminated due to the receipt of signal number 11Please download the latest patches for all components of TPT and try again. There are separate packages for the Big-4 (Load, Update, Export, Stream) operators and the TPT infrastructure (the ODBC ...
49012 Sep 2013 @ 05:56 PDTToolsReplyTeradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003Is the file really in the C:\ directory? Do you have read access to that file and directory (have to ask that question)? Please add a screenshot or something. Do not worry about the message numb...
48912 Sep 2013 @ 03:09 PDTToolsReplyCan we load the same table concurrently using TPT Update operator by setting seperate checkpoint filesYes. That will be one way of queuing up jobs using the Update operator when multiple jobs want to target the same table. (I was assuming the original question implied you wanted to jobs at the sam...
48812 Sep 2013 @ 01:09 PDTToolsReplyimport huge data very quickly -- Fastload/Tpump/MLOADOur utility reference manuals have all of the information you need. You may find them here: http://www.info.teradata.com/
48703 Sep 2013 @ 06:01 PDTToolsReplyfastload insertion The message is "RDBMS", meaning it came from Teradata. It is not a TPT error. You have introduced syntax that is not allowed by Teradata for the FastLoad protocol. You will have to s...
48603 Sep 2013 @ 09:15 PDTToolsReplyTPT load source files with regular expressionAnother thought: If you are trying to load the data from all 5 files, but you know you need to use 2 different load tasks to accomplish the job, you can use one step to load the files from ABC_AAA_...
48503 Sep 2013 @ 09:13 PDTToolsReplyTPT load source files with regular expressionTPT does not support "ABC_AAA_[0-9].dat" syntax. If you want to use the wildcard syntax, all files must adhere to the same layout. Thus, in this particular scenario, due to the way the ...

Pages