#DateForumTypeThreadPost
120922 Aug 2016 @ 08:56 PDTToolsReplyZero records are fetching when using where statement in TPTIf you tried to put the SELECT statement in the script, please send me your script and I will make adjustments as necessary.  
120819 Aug 2016 @ 03:56 PDTToolsReplyUnicode Export through TPTPlease send me your script. (I may make changes to it.)  
120719 Aug 2016 @ 03:07 PDTToolsReplyUnicode Export through TPTIn the example script you sent, EmpCatNumber was defined in the table as VARCHAR(10). If that is the case, then the script must specify VARCHAR(30). If this is done correctly, I am not sure how T...
120619 Aug 2016 @ 01:43 PDTToolsReplyUnicode Export through TPTIn order to see the chinese/japanese characters, you MUST specify either UTF8 or UTF16 as the character set in the script.   If you specify UTF8, you must triple the size of the character fi...
120516 Aug 2016 @ 02:04 PDTToolsReplyTPT - Instances Vs SessionsSince you are using templates, you will need to use the template job variable name. It could be FileReaderMultipleInstances. To be sure, take a look at the $FILE_READER.txt template file.  
120416 Aug 2016 @ 08:41 PDTToolsReplyTPT - Instances Vs SessionsIn order to use multiple instances to read from a single file, you must set the MultipleReaders attribute to 'yes'.
120315 Aug 2016 @ 10:58 PDTToolsReplyUnderstanding teradata sample scriptsThe $FILE_WRITER and $LOAD syntax describes the use of templates. Those templates define the operators you are trying to use, and those operator definitions are found in the "templates" ...
120210 Aug 2016 @ 11:46 PDTToolsReplyTPT load failure - Please suggestSince an incident has been opened for this, I will let the GSC handle it for now. If they need to come to engineering, then I will get involved to help them. (That message it provided by the DBS ...
120109 Aug 2016 @ 08:46 PDTToolsReplyTPT load failure - Please suggestWhat version of TPTAPI have you installed? What version of CLI? This sometimes can occur when mismatching components are installed.  
120009 Aug 2016 @ 08:29 PDTToolsReplyQueries for Teradata Fast Export Utility1. FastExport should be installed on the edge node. It should never be installed on the database server. 2. It has been shown that a max session count of 4 is generall the best setting, but you ca...
119909 Aug 2016 @ 08:25 PDTToolsReplyTPT export into AWS S3 buckets.We are currently developing an Amazon AWS S3 access module that will allow you to move data from S3 directly into Teradata (and vice versa) without landing the data to disk. It is not yet released....
119827 Jul 2016 @ 12:20 PDTToolsReplyDelimiter issue in FastloadThe Data Connector (we do not really refer to it as "legacy" since it is used by BTEQ, which is not a frozen product) does support quoted delimited data (as does FastLoad, MultiLoad and T...
119726 Jul 2016 @ 11:28 PDTToolsReplyExport with header using TPTThe Export (and SQL Selector) operator(s) is/are not capable of extracting out the column headers from the database.  
119625 Jul 2016 @ 11:06 PDTToolsReplyTPT 15.10 ODBC Operator : Bundled DataDirect Drivers !This is not true. We bundle both the 32-bit and 64-bit drivers with TPT. You do not have to purchase the license from DataDirect. However, you do need to obtain the license files from us.  
119525 Jul 2016 @ 02:13 PDTToolsReplyCtrl-A delimiter with TPT Export.There is an attribute for the DataConnector operator (I think still undocumented) called TextDelimiterHex. Set that to '0A' and the DC operator should write out that character as the field...
119421 Jul 2016 @ 04:23 PDTToolsReplyZero records are fetching when using where statement in TPTOur documentation will describe examples, and we ship sample scripts with TPT. Look in the "samples" directory where TPT is installed.  
119321 Jul 2016 @ 04:22 PDTToolsReplyTPT Export vs Fast ExportYes, TPT supports the writing of data to multiple files. Just use the Export operator to extract the data from Teradata. Use the DataConnector operator as the file writer. Specify how many insta...
119221 Jul 2016 @ 03:50 PDTToolsReplyTPT - ScriptingThere is currently no way to force tdload to use a specific operator. (It is on the list for a future enhancement.) To force the use of a specific operator, you would need to write a script. (Al...
119120 Jul 2016 @ 01:39 PDTToolsReplyZero records are fetching when using where statement in TPTIf you write a script and put the SELECT statement in the script, the single quotes will not be stripped.
119019 Jul 2016 @ 11:23 PDTToolsReplyZero records are fetching when using where statement in TPTI have enough information. I needed to know if the single-quotes were being stripped.  
118919 Jul 2016 @ 09:45 PDTToolsReplyTDCH-TPT Interface--For loading into HadoopThe use of TDCH by TPT is basically performed by TPT sending a command to the name node of the Hadoop cluster to execute the TDCH command, passing the needed information as command line options to ...
118819 Jul 2016 @ 09:21 PDTToolsReplyTPT - ScriptingWhat version of TPT are you using? That would dictate what type of "template" and "generated schema" features you can use. It would also dictate whether you can use Easy Loade...
118719 Jul 2016 @ 09:11 PDTToolsReplyZero records are fetching when using where statement in TPTFor your versiobn of TPT, continue to use SelectStmt. We are "fixing" TPT to also accept ExportSelectStmt, but that is not completed yet. I will need to see a complete log (the .out fil...
118619 Jul 2016 @ 09:07 PDTToolsReplyDetermine #sessions to set for load / exp jobsThe calculation that is often used in TASM (TDWM, workload management) is:   If number of AMPs <= 20, then use 1 per AMP. If number of AMP > 20, then use 20 + (#AMPS/20)   But ...
118515 Jul 2016 @ 12:30 PDTToolsReplyTPT Export vs Fast ExportFastExport will process the blocks in order. TPT Export can have multiple processes, each process controlling multiple data sessions, and thus you can get parallelism extracting the data from Tera...

Pages