#DateForumTypeThreadPost
68409 Jun 2014 @ 09:00 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementFirst of all, when you use a character set of UTF8, the sizes of the CHAR/VARCHAR columns must be 3x the definition of the columns in Teradata. That is because the size of the column in Teradata (a...
68305 Jun 2014 @ 05:54 PDTToolsReplyTPT - Format = text exampleWhat version of TPT are you using? Can you put the single column data in quotes? If so, then the processing will ignore anything in the quotes that might be considered the delimiter.
68205 Jun 2014 @ 04:56 PDTToolsReplyTPT load failure - Please suggestWhat is the version of TPT? What is the platform?  
68105 Jun 2014 @ 04:30 PDTToolsReplyCan we Delete Data in source (Oracle ) table after loading data into Target (Teradata) table in TPT?TPT is a suite of load tools for Teradata. We are able to pull data out of Oracle, but TPT does not perform any other actions against non-Teradata databases.  
68004 Jun 2014 @ 11:14 PDTToolsReplyDate value mismatch btw delimited file and source tableWhich column is failing? What is the exact error you are getting from TPT (or is the job completing successfully, but the data is incorrect)? What version of TPT are you using? What platform? S...
67903 Jun 2014 @ 05:25 PDTToolsReplyTPT: using VARDATE and empty stringWe will put it on our list of enhancements for the future. Thanks!
67803 Jun 2014 @ 01:25 PDTToolsReplyDate value mismatch btw delimited file and source tableTry VARCHAR ReportModeOn = 'yes'  
67703 Jun 2014 @ 10:38 PDTToolsReplyDate value mismatch btw delimited file and source tableWhen using the Selector operator, you need to enable the ReportModeOn attribute. You have assigned a value to that attribute (default is "no").   What version of TPT are you using...
67602 Jun 2014 @ 08:52 PDTToolsReplyTPT - Format = text exampleI am not sure whether a shorter or longer delimiter will affect performance, but I thought if someone did not know what delimiter they should pick, they would choose something with punctuation mark...
67530 May 2014 @ 01:10 PDTToolsReplyCHAR(n) CHAR SET UNICODE/LATIN define schema in 14.xx - multiply by 2 or 3If you are uncertain about your data, you are better off using VARCHAR instead of CHAR. Less traffic across the network (as you pointed out). We only send what we receive. As far as resources to ...
67430 May 2014 @ 10:11 PDTToolsReplyCHAR(n) CHAR SET UNICODE/LATIN define schema in 14.xx - multiply by 2 or 3TPT does not know anything about the table definition of the source table, whether the columns are of type LATIN or UNICODE.   We only work off of the client session character set. Database...
67329 May 2014 @ 05:44 PDTToolsReplyError on Launching Fast Export - Missing _LaunchUtilityDid you intend to use the OLE-LOAD access module? What was your intention when using FastExport? What version of FastExport are you running? Incidentally, FastExport is a 32-bit application. If ...
67229 May 2014 @ 03:55 PDTToolsReplyTPT adding spaces for nvarchar datatype while loading6705 An illegally formed character string was encountered during translation.   Explanation: This error occurs when in a string containing Multi-Byte Characters (MBC), the MBCs are not compl...
67129 May 2014 @ 11:53 PDTToolsReplyTPT adding spaces for nvarchar datatype while loadingI would need to see more information (exact errors) in order to better figure out what is going on. Also, I need the error code from the error table and the column name. One more thing to keep in...
67029 May 2014 @ 11:25 PDTToolsReplyTPT: using VARDATE and empty stringVARCHAR and VARDATE are 2 different things. Different code paths. Different functionality. VARDATE is specific to Dates/Times/Timestamps. And once you use the formatting options, it expects cert...
66929 May 2014 @ 11:19 PDTToolsReplyTPT - Format = text exampleIf each record has a single column, then you do not need a delimiter. Curious: why did you pick such a large delimiter?
66828 May 2014 @ 07:15 PDTToolsReplyTPT API : Setting DSNName attribute through TPT API script for a source databaseSQLSTATE 8003 means "connection does not exist".
66728 May 2014 @ 05:23 PDTToolsReplyTeradata - Fast Export OptionNo, there is no option to generate a FastLoad script.  
66628 May 2014 @ 04:00 PDTToolsReplyTPT adding spaces for nvarchar datatype while loadingI believe that "nvarchar" is used when the data has Unicode characters. Thus, the use of UTF16 is probably the right choice (but I do not know that content of your data). The fact that ...
66528 May 2014 @ 02:56 PDTToolsReplyTPT: using VARDATE and empty stringYes, I am sure. I do not think it is strange. You are not providing anything to convert. The feature converts data from one format to another. What is VARDATE supposed to convert from/to? If yo...
66428 May 2014 @ 02:00 PDTToolsReplyTPT adding spaces for nvarchar datatype while loadingPlease provide your script and the DDL of the source and target tables.
66328 May 2014 @ 10:36 PDTToolsReplyTPT: using VARDATE and empty stringThe idea behind VARDATE is to convert data. An empty field contains no data to convert. The VARDATE feature is not intended to insert some type of default value.
66227 May 2014 @ 07:42 PDTToolsReplyTPT - Can you load from a file containing multiple record types?TPT does not support multiple schemas in a single input file.
66123 May 2014 @ 06:36 PDTToolsReplyTPT - Can you load from a file containing multiple record types?Yes. First of all, every record must adhere to a single schema. That is the most important rule to remember.   If the data is in delimited format, then we have a feature whereby short rows ...
66021 May 2014 @ 11:25 PDTToolsReplyQuestion - can MQ be a DataConnector Consumer?Our MQ Access Module does not currently support writing to the queue. It is on our list of features to consider. There are no plans or commitments for this task right now.  

Pages