#DateForumTypeThreadPost
115923 Jun 2016 @ 07:49 PDTToolsReplyTPT Failure : Output schema mismatch - Output varies from Server to Server.Please provide the DDL of the source table. I notice that the script is not indicating the use of the UTF8 client session character set, so not sure how Unicode could affect this, but the table de...
115823 Jun 2016 @ 11:48 PDTToolsReplyNeed Help regarding TPT ODBC OperatorBTW, the reason why the actual text messages were not output was because of this:   They are regular messages which arise when the license is not available. Looks like he is using multiple O...
115723 Jun 2016 @ 11:17 PDTToolsReplyNeed help with Conflicting Column Count in TPTWhat exact version of TPT are you running? I might need you to enable the operator trace for the Export operator and send me the binary log from the job (to me email). In the meantime, I am inves...
115623 Jun 2016 @ 10:35 PDTToolsReplyNeed Help regarding TPT ODBC OperatorThe ODBC license files for the bundled DataDirect drivers are provided at no charge, but they must be obtained from our Product Management group, as they track to which customers they supply the li...
115522 Jun 2016 @ 06:13 PDTToolsReplyTPT and Windows PowerShellCan you print out the PATH environment variable and send it? TPT looks at that in order to start up the application.
115422 Jun 2016 @ 03:51 PDTToolsReplyTdload failing with TPT02638: Error: Conflicting data lengthHow are you specifying the username, and what is the error you get?  
115322 Jun 2016 @ 10:56 PDTToolsReplyNeed Help regarding TPT ODBC OperatorYou are correct, my bad. I was unaware that our bundled drivers would act that way (but checked with the developer to make sure and you are correct). The bundled drivers will allow a 15 day trial...
115222 Jun 2016 @ 10:54 PDTToolsReplyTPT Work/error Tables always protected (FALLBACK) ?The error tables are created as FALLBACK for the protection of the user so that the jobs can run in the event of a down AMP in a cluster. Right now there is no way for the user to indicate to us t...
115121 Jun 2016 @ 01:37 PDTToolsReplyTPT RestartabilityUse the -s 1 command line option. It forces the job to delete the checkpoint restart files and start from the first job step. There is no script command. And you HAVE to delete the checkpoint re...
115021 Jun 2016 @ 09:23 PDTToolsReplyTPT API C program usage64K.
114920 Jun 2016 @ 12:16 PDTToolsReplyEasy Loader Skip Column in Flat FileThis is not currently available with "tdload".   In order to do this, you would need a script so that the "SELECT" portion of the APPL-SELECT canbe used to filter out the...
114820 Jun 2016 @ 11:39 PDTToolsReplyNeed Help regarding TPT ODBC OperatorThe bundling of DataDirect drivers was first supported with TPT 14.10.00.06. If you upgrade to that efix level, you will get the drivers. However, you do need license files in order to use the dr...
114717 Jun 2016 @ 10:11 PDTToolsReplyUsage of GetRow method in TPT API for exporting table data into csvTPTAPI does not write out to a file. That is up to your application. Thus, if your file is empty, you will have to debug your application.   The data that will be provided from a call to Ge...
114617 Jun 2016 @ 09:59 PDTToolsReplyTDCH-TPT InterfaceTPT is a client application and we have no control over AMP CPU usage. I would not be able to help there.  
114517 Jun 2016 @ 09:27 PDTToolsReplyTDCH-TPT InterfaceI am glad you were able to get the HDFS method working. As to which method to use, that would be up to you. We do not run performance comparison tests. The method that performs the best for you ...
114416 Jun 2016 @ 10:55 PDTToolsReplyTDCH-TPT InterfacePlease provide your script and version of TPT.  
114315 Jun 2016 @ 06:12 PDTToolsReplyTDCH-TPT InterfaceReading/writing from/to Hadoop files via HDFS are no different than accessing them from the local file system. You give us the name and the directory and the format. The only difference that is m...
114215 Jun 2016 @ 06:09 PDTToolsReplyProblems with multibyte tdload / TPT19134 !ERROR!Do you happen to know if that character is a 4-byte UTF8 character?
114114 Jun 2016 @ 10:11 PDTToolsReplyTDCH-TPT InterfaceIf you are writing the data to HDFS, why not just use TPT's HDFS interface?  
114014 Jun 2016 @ 10:08 PDTToolsReplyCan TPT be used to load file with 10M records of 3500 attributes ???Please explain what you mean by "attributes"? Will each field in the delimited file be loaded into a column of a table in a Teradata Database? An example of a record from the file would...
113910 Jun 2016 @ 09:01 PDTToolsReplyTPT attributes SkipRows and SkipRowsEveryFileNo. You either skip the 'n' rows in one file or all.
113809 Jun 2016 @ 11:51 PDTToolsReplyTPT attributes SkipRows and SkipRowsEveryFileThe DataConnector operator is able to read from multiple files at one time. The nature of parallelism implies that order is not important. If order is important, you cannot read multiple files in...
113708 Jun 2016 @ 11:14 PDTToolsReplyTPT API C program usageYes.
113607 Jun 2016 @ 10:13 PDTToolsReplyTPT API C program usageI am reminded by the developer that the TPTAPI Export operator does not need a list of columns (a schema).   The Export operator has a "dynamic schema" feature in which the operato...
113506 Jun 2016 @ 10:22 PDTToolsReplyNeed Help regarding TPT ODBC OperatorCheck your PATH environment variable. Maybe the installation was not completed correctly.  

Pages