#DateForumTypeThreadPost
80919 Jan 2015 @ 11:36 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)Sorry, I forgot to ask what version of TPT you are using. The QuotedData feature was introduced in TPT 14.0. If you are using a version prior to that, then the quotes will always be part of the d...
80816 Jan 2015 @ 01:14 PSTToolsReplyTPT Loading DateTime (SQL Server) with UTF-16 char setThe original script had a schema with CHAR(46) and a 'convert' in the SELECT to CHAR(23). That should have worked. Timestamps are fixed length CHAR fields, not VARCHAR. The fact that the...
80716 Jan 2015 @ 01:05 PSTToolsReplyTPT - source data enclosed with double quotes and delimited by pipe (|)You must enable the quoted data feature by setting the QuotedData attribute in the DataConnector attribute to 'yes' or 'optional'.   Please refer to the documentation for det...
80615 Jan 2015 @ 07:20 PSTToolsReplyTPT Loading DateTime (SQL Server) with UTF-16 char setI will continue to look into this. I just installed SQL Server onto my PC and created a table with a DataTime column and inserted a single column/row with value: 2014-03-04 12:13:14.123 If I do ...
80515 Jan 2015 @ 11:55 PSTToolsReplyTPT Loading DateTime (SQL Server) with UTF-16 char setGranted I do not have SQLServer on my PC, but when I do an export from Teradata and then a load into Teradata, with TIMESTAMP(3) in the schema, and the value of the timestamp column in the source t...
80414 Jan 2015 @ 11:43 PSTToolsReplyHow can I perform the same with a TPT script ?BTEQ can sometimes be viewed as a report writer type of tool. TPT is not. TPT is a data loading tool (yes, it can export from a database as well, but the power of TPT is in its loading). TPT can...
80314 Jan 2015 @ 11:39 PSTToolsReplyTPT Loading DateTime (SQL Server) with UTF-16 char setWhy does your schema have CHAR(48) instead of TIMESTAMP(3)?
80213 Jan 2015 @ 04:45 PSTToolsReplyIssue with my first Teradata PTUnfortunately, hard to help without more information. You would need to provide screenshots of BTEQ commands or some other tool showing the before and after of the load of the target table (in a w...
80112 Jan 2015 @ 10:28 PSTToolsReplyTPT : ERROR using BYTE data comparison in JOBSCRIPTThe TPT syntax does not yet support "XB" format.
80012 Jan 2015 @ 08:36 PSTToolsReplyFastLoad parallel sessions limit. Is it overridable?There is no way to override this. (The limit was 5, then was raised to 15, and now it is 30.) It is found that trying to run more than 30 concurrent FastLoad/MultiLoad jobs can actually slow perf...
79907 Jan 2015 @ 09:09 PSTToolsReplyTPT ODBC OperatorYou will most likely have to get to Teradata At Your Service. I do not know the link.  
79806 Jan 2015 @ 11:51 PSTToolsReplyTeradata tptWell, this thread is probably not the proper place for this topic. You should start a new thread/topic. TPT is too large of a product to answer in a single post.   We have documentation fo...
79706 Jan 2015 @ 11:47 PSTToolsReplyTPT - BUFFERMAX errorGood to hear. Thanks for your patience.
79606 Jan 2015 @ 11:00 PSTToolsReplyTPT - BUFFERMAX errorJust researched and found that it is fixed in 14.10.00.03. Please download the latest 14.10 efix patches and try again. Thanks!
79505 Jan 2015 @ 09:58 PSTToolsReplyTPT - BUFFERMAX errorCan you provide a sample of the data? Each record of the file has to have an end-of-record marker.  
79405 Jan 2015 @ 06:56 PSTToolsReplyTPT - BUFFERMAX errorDoes the file name in the file list have an end-of-line marker? If not, please add one and then try again.  
79305 Jan 2015 @ 06:45 PSTToolsReplyTPT - BUFFERMAX errorFirst of all, when looking at your script, I see this:   VARCHAR PrivateLogName='/ngs/app/etld/work/naveen/loadmeprivatelog',   The private log name is just the name of a virt...
79205 Jan 2015 @ 03:51 PSTToolsReplyTeradata tptMultiLoad is only a load tool, so not sure what you mean be "archive". MultiLoad can load csv data. The record format is called "vartext". In the schema definition, all column...
79105 Jan 2015 @ 10:38 PSTToolsReplyTPT ODBC OperatorThe support of the bundling of the drivers was done post-GCA in an efix. Please download all of the latest 15.0 efix patches TPT. You will then need to contact Mark Haydostian (Mark.Haydostian@Te...
79005 Jan 2015 @ 08:54 PSTToolsReplyTPT Load Operator Table LockIf you are using the Load operator, the only way to release a lock is to complete the Application Phase.   The only other option is to drop the target table (and error tables) and start the ...
78931 Dec 2014 @ 08:46 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsAfter the holidays we will take a look. Inconsistent? I would just call it wrong, if it is true.   Ivy posted above that she showed a VARTEXT job loading blanks into the DBS and not NULL whe...
78830 Dec 2014 @ 11:20 PSTToolsReplyWrite Hierarchial file using Fast exportThe basic answer to the question is "no".   The record formats are explicitly documented in the FastExport manual and hierarchical records are not supported.  
78729 Dec 2014 @ 05:35 PSTToolsReplyNamed Pipe jobs failing on checkpoint fileI am not quite sure what you mean by TPTLOAD "named pipe" jobs. I am assuming you mean that the job is sending the data through named pipes to the Load operator. Since you also mentione...
78629 Dec 2014 @ 10:31 PSTToolsReplyTeradata tptA string attribute value must be enclosed with single quotes. Thus, you need to escape the single-quotes inside that string. You need to double all of the single quotes insidfe the quoted string....
78524 Dec 2014 @ 10:13 PSTToolsReplyHow to execute a macro using TPT operator?As already noted, TPT does not currently support conditional logic. As far as I know there is no other way to simulate conditional logic. Why do you want to convert a BTEQ script to TPT?  

Pages