#DateForumTypeThreadPost
70930 Jun 2014 @ 09:24 PDTToolsReplyTPT DSN ErrorYes, it was related to 64-bit TPT. The Microsoft driver needed something set explicitly whereas the DataDirect driver did not (accepted our default setting).   We always recommend that you ...
70830 Jun 2014 @ 04:28 PDTToolsReplyTPT DSN ErrorIn the meantime, you can always download a free 15-day evaluation copy of the DataDirect drivers.
70730 Jun 2014 @ 04:27 PDTToolsReplyTPT DSN ErrorActually, 15.00.00.02 may not have been released yet. Looks like it is schedule for mid-July.  
70630 Jun 2014 @ 04:23 PDTToolsReplyTPT DSN ErrorThis is a known issue and has been fixed in 15.00.00.02 (you are running 15.00.00.00). Please download the latest 15.00 patch/efix. Thanks!  
70530 Jun 2014 @ 11:25 PDTToolsReplyTPT load failure - Please suggestWe fix issues all of the time. We are currently in development for the 15.10 release. This means that bug fixes have occurred for 13.0, 13.10, 14.0, 14.10, and 15.0. When bugs are found in newer...
70430 Jun 2014 @ 09:30 PDTToolsReplyz/OS Mainframe TPT RECFM=FB versus LRECL=VB I am told by the developers that this issue has been fixed. You will need at least 13.10.00.13, but always best to upgrade to the latest efix.   I posted the latest versions above. To be s...
70330 Jun 2014 @ 09:24 PDTToolsReplyz/OS Mainframe TPT RECFM=FB versus LRECL=VB First let me clear up one thing. Indicator bytes are never written at the end of a record. What you are seeing are pad bytes written out. I have our mainframe developer looking into this. Clear...
70227 Jun 2014 @ 05:06 PDTToolsReplyz/OS Mainframe TPT RECFM=FB versus LRECL=VB Did you try adding up the column sizes by hand? The operator is reporting 383 bytes. That 383 might include the indicator bytes. Which means the actual record length being written out is 375. W...
70127 Jun 2014 @ 01:46 PDTToolsReplyz/OS Mainframe TPT RECFM=FB versus LRECL=VB Just checked. Here are the latest patches: TPT Infrastructure 13.10.00.19 TPT Export Operator 13.10.00.07 TPT Load Operator 13.10.00.05 TPT Stream Operator 13.10.00.09 TPT Update Operator 13.1...
70027 Jun 2014 @ 01:22 PDTToolsReplyz/OS Mainframe TPT RECFM=FB versus LRECL=VB I believe the latest patch is #15, #16 or #17. I cannot list all of the bug fixes (too many). I understand that you are on an enterprise system, but if you have access to a single test system and...
69927 Jun 2014 @ 11:33 PDTToolsReplyTPT load failure - Please suggestPlease post the script you are using. Thanks!
69827 Jun 2014 @ 10:54 PDTToolsReplyz/OS Mainframe TPT RECFM=FB versus LRECL=VB Those are not indicator bytes. They might be garbage characters. We have made several bug fixes in this area. Please upgrade to the latest version of TPT 13.10 and re-run the job and see if the p...
69727 Jun 2014 @ 10:10 PDTToolsReplyQlikview TPT ConnectorYou mention that you are using "QVX_TPTConnector", but the output shows FastExport. FastExport is not part of any TPT connector. They are different products.   However, for this pa...
69627 Jun 2014 @ 10:03 PDTToolsReplyTPT load failure - Please suggestPlease upgrade to the latest efix version and try again. If the problem persists, let me know (and let me know what version you used).  
69525 Jun 2014 @ 11:28 PDTToolsReplyTPT load failure - Please suggestWhat exact version of 13.0? We have released several patches since its GCA version. And 13.0 is not an officially supported version of TPT, so my first response is for you to update TPT to the la...
69419 Jun 2014 @ 12:02 PDTToolsReplyRunning multiple concurrent TPT INSERTER jobs on one server - seeing long wind-downI would need to see the script(s), and the command lines. Are you running 12 different TPT scripts? Did you give each job its own unique name? Are the jobs loading different target tables? What...
69319 Jun 2014 @ 11:18 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';The reason for the DATE not working is because the data for that column is being exported in ANSI format (equivalent to a CHAR(10)) whereas the target table is being interpreted as the standard Ter...
69218 Jun 2014 @ 02:51 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';Just to warn you: EasyLoader is a means to load data only. You would have to drop tables and create tables outside of that tool. If you would rather have a single script to do that, then stick wit...
69118 Jun 2014 @ 02:24 PDTToolsReplyTPT Statement Not Working: DEFINE SCHEMA <SchemaName> FROM TABLE '<TableName>';I will look into the issue you are having, but in the meantime, I have a question. If all you are doing is moving data from one table to another, have you tried using the "EasyLoader" fe...
69018 Jun 2014 @ 11:33 PDTToolsReplyTPT Load Operator Table LockPlease explain your concern about the locks on the AMPs for that table. If you are concerned about the amount of time the locks remain on the table, then the FastLoad or MultiLoad protocol should ...
68917 Jun 2014 @ 03:59 PDTToolsReplyTPT Load Operator Table LockI suppose it might depend on how much data is loaded and how much time you spent on the original job.   If the original job loaded 90% of the data, you might be better off unlocking the tabl...
68816 Jun 2014 @ 12:13 PDTToolsReplyWill TPT INSERTER operator lock the target table if an INSERT step fails?No, the INSERTER operator will not leave the table in a locked state. That is because it uses plain SQL sessions to load the table. The LOAD operator uses the FastLoad protocol and that protocol ...
68716 Jun 2014 @ 10:08 PDTToolsReplyEXPORT_OPERATOR: TPT12108: Output Schema does not match data from SELECT statementThe only check we make is a comparison between the the result of the SELECT statement and the schema definition (the target table definition is immaterial; the DBS will do any necessary conversions...
68611 Jun 2014 @ 12:24 PDTToolsReplyTPT Export to Mainframe File - RDBMS error 3177Ok, I see that you are using this for the Export operator:     INTEGER MAXRESPSIZE = 1048575,              &nbs...
68509 Jun 2014 @ 09:07 PDTToolsReplyTPT - Format = text exampleWill your data have tab characters? You can specify the delimiter as:   VARCHAR TextDelimiter = 'TAB'   (Yes, I know; strange)   If not, we have an undocumented featur...

Pages