#DateForumTypeThreadPost
78424 Dec 2014 @ 10:08 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsThere might be another way. You mentioned that you have fixed length fields. This usually means you are using the TEXT format and not VARTEXT. Have you tried the TRIM function. A field of all b...
78324 Dec 2014 @ 10:06 PSTToolsReplyMLOAD and loading of: Empty Strings and Null StringsAny column value with all blanks should be loaded as a column of all blanks. Not NULL or empty string. The only way to load an empty string is to use the quoted vartext feature and quote your data....
78222 Dec 2014 @ 01:13 PSTToolsReplyTPT & Quoted data bug?This issue was fixed in 14.10.00.06. Always a good idea, though, to download all of the latest patches for all packages of TPT 14.10.
78122 Dec 2014 @ 09:23 PSTToolsReplyTPT log file when run from InformaticaScript-based TPT is a batch job that runs by itself. When Informatica is used, the ETL tool uses TPTAPI, meaning it has direct access to the operators themselves, but there is no TPT "job&quo...
78017 Dec 2014 @ 08:24 PSTToolsReplyTPT ODBC OperatorTPT 13.10.00.04 is quite old. I think the infrastructure (which includes the ODBC operator) is up to 13.10.00.20. I suggest you go to the patch server and download the latest patches for all of t...
77916 Dec 2014 @ 11:48 PSTToolsReplyPT job with Oracle and Informix ODBC operator errorTPT 13.0 only runs in 32-bit mode, so yes we are only certified with the 32-bit versions of the drivers.  
77816 Dec 2014 @ 11:37 PSTToolsReplyTPT ODBC OperatorTPT is only certified with ODBC drivers from Progress DataDirect.   You are free to use whatever ODBC drivers you like, but we will only offer support when you use the ones from Datadirect. ...
77715 Dec 2014 @ 02:43 PSTToolsReplyTeradata tpt3. Why would you want to export from TPT and load back in with MultiLoad? Why not just load back in with TPT?   2. For delimited output, it depends on which version of TPT you are using. Ear...
77615 Dec 2014 @ 08:41 PSTToolsReplyTeradata tptThe TPT documentation has sample scripts to help you with this. When you install TPT, there is also a samples directory with sample scripts for all of the popular scenarios (like the one you seek)...
77511 Dec 2014 @ 05:52 PSTToolsReplyFast Export Data File IssuePlease provide more detailed information. Please provide the output of the job itself (all of the commands and information), and then provide the actual data from the data file (even if you have t...
77403 Dec 2014 @ 11:10 PSTToolsReplyTPT and Windows PowerShellPlease do NOT use tbuildexe.exe to run TPT! That is not the right approach and we will not support you when you do this. TWB_ROOT is NOT an environment variable that the user should be setting at...
77303 Dec 2014 @ 09:54 PSTToolsReplyTPT ODBC OperatorStarting in TPT 15.0 we bundle the DataDirect drivers with TPT. You will need to download the latest efix patches in order to use those bundled drivers.  
77201 Dec 2014 @ 06:04 PSTToolsReplyTPT SelectStmtI have never seen the escaping fail.   Therefore, please upgrade to the latest version of 14.00 (efix #3 is a very old version of the 14.0 release) and see if that fixes your problem.  
77120 Nov 2014 @ 01:39 PSTToolsReplyLimitation of Reading number of Fields in TPTMost likely because Teradata only supports 2048 columns. (My other questions were not answered.)  
77017 Nov 2014 @ 09:26 PSTToolsReplyTPT Vs other ETL UtilitiesEach load job is independent of each other and so it depends on your system memory availability and your virtual memory settings.   Each job, by default, will allocate 10MB of shared memory ...
76910 Nov 2014 @ 09:58 PSTToolsReplyTPT 15.00 Teradata <> HDP Sanbox data movementTo better diagnose the issues, I would need to see the entire script. There are inconsistencies in what is presented. 1. you mention TPT Export operator, but the Export operator only supports Ter...
76806 Nov 2014 @ 12:54 PSTToolsReplyhow to select sessions,tenacity,sleep,checkpoint etc for fastload,multiload,tpump utilitiesIf you are only loading 1 message at a time (and I am assuming that 1 message means 1 row), then 1 session is fine, and you should set the pack factor to 1 so that the row is sent immediately (and ...
76731 Oct 2014 @ 10:53 PDTToolsReplyTPT load failure - Please suggestYes.
76631 Oct 2014 @ 10:24 PDTToolsReplyTPT load failure - Please suggestTalk to your account rep about the download site. This issue is specific to using the Microsoft SQLServer driver. (If you had used the DataDirect driver, you would not have seen this problem.) T...
76530 Oct 2014 @ 06:04 PDTToolsReplyTERADATA 13.10 - DATASTAGE 8.5 Issues with FastLoad functionalityDoes DataStage 8.5 use FastLoad, or TPT? If TPT, the SYSADMIN.FASTLOG is not used anymore.
76430 Oct 2014 @ 05:19 PDTToolsReplyTPT load failure - Please suggestWhat ODBC driver are you using? What (exact) TPT version are you running? The fix to the problem is fixed in 15.00.00.02.  
76330 Oct 2014 @ 01:07 PDTToolsReplyODBC Operator and Window AuthenticationIn a perfect world, yes it would be nice to support every ODBC driver with our ODBC operator. However, for us to "support" them, we would need to "certify" with them. We have ...
76229 Oct 2014 @ 07:55 PDTToolsReplyODBC Operator and Window AuthenticationTPT is only certified with the ODBC drivers from Progress DataDirect. Use of any other ODBC driver is unsupported. Thus, you would have to talk to Crystal Reports about the issue you are receivin...
76129 Oct 2014 @ 11:24 PDTToolsReplyTPT Template operators with LDAP authenticationYes, it looks like 14.10.00.05 does have the fix for this issue. (Yes, you have the correct jira.)
76027 Oct 2014 @ 06:52 PDTToolsReplyMLOAD ERROR : "UTY4019 Access module error '4' received during 'File open' operation: 'Requested file not found' "Which access module are you using? What version of MLOAD are you using?  

Pages