#DateForumTypeThreadPost
4026 May 2015 @ 02:33 PDTConnectivityTopicInstall DBD::ODBC using DataDirect Driver ManagerPlease help.  Vhari, you helped me on this in the past and I'm hoping you can help here as well.   I've actually got this working last year, however we have moved to a new serve...
3923 Jan 2015 @ 06:42 PSTDatabaseReplyTPT Table LoadThanks for the post.  It's funny because we just put in that primary key the other day and I actually forgot to update the load file with it.  So thanks for that.  But, prior to ...
3821 Jan 2015 @ 09:41 PSTDatabaseReplyTPT Table LoadHi, I'm not sure about the NoPI Table.  Basically I took the example load table file included in the tpt install and updated it as follows:   /***********************************...
3717 Jan 2015 @ 03:29 PSTDatabaseTopicTPT Table LoadWe are loading large amounts of data into a table using TPT and it works fine.  I have my attr file setup to load to a certain table, but the only issue I have is that when the TPT load is suc...
3604 Dec 2014 @ 09:59 PSTToolsTopictbuild with -v optionHi, I wanted to run the tbuild command using the local variables file.  Currently I have it running successfully without the -v option, but the local file is in the same path as the tpt script...
3510 Jul 2014 @ 07:11 PDTToolsTopicQuestion on Failed TPT LoadIf a TPT load fails and the restart is not working can someone tell me what has to be done to get the load to start over again.  I know that I have to drop the load table and the tables with t...
3414 May 2014 @ 08:01 PDTConnectivityReplyTeradata DB connection using ODBC Thru IBM Information Server DataStageDoes anyone have any clues as to why the prior posts attempt at the 'make test' is failing.  Everything appears to be in place.  It finds the Intersolve driver manager and headers...
3309 May 2014 @ 10:26 PDTConnectivityReplyTeradata DB connection using ODBC Thru IBM Information Server DataStageHello again Vhari.  If you could take a look at this I'd appreciate it.  After getting this working in a custom directory we wanted to install this into the standard paths with root. ...
3207 May 2014 @ 07:47 PDTToolsReplytbuild - message catalog related environment variable for AIXActually I found the problem.  As a non root user you must export TWB_ROOT into your .profile.  
3107 May 2014 @ 07:08 PDTToolsReplytbuild - message catalog related environment variable for AIXI installed version 14.00 of TPT on RedHat, configured my Load file and am executing the tbuild script via perl.  Everything works fine when executing the script from the command line.  H...
3006 May 2014 @ 05:05 PDTToolsReplyTeradata TPT ScriptHi Feinholz, I've got another question.  I'm running this from a non-root user and under crontab the tbuild run doesn't fire.  It does run fine when kicking off the script fro...
2906 May 2014 @ 09:02 PDTToolsReplyTeradata TPT ScriptThe last issue I'm having is an error from an sql to the Table after the TPT script load succeeded.  I have 2 tables currently being loaded.  One is with a DBD::ODBC module, which is ...
2805 May 2014 @ 05:09 PDTToolsReplyTeradata TPT ScriptAlmost got it.  I ran the script but accidently had an extra column in the test file I was inserting.  So after fixing that, dropping and creating the table, I am getting this error on th...
2705 May 2014 @ 02:41 PDTToolsReplyTeradata TPT ScriptI've done the following: 1) Created the empty table in Teradata 2) Created the TPT script with the corresponding table schema.  However the 1st column in my table has the name '#TIME...
2605 May 2014 @ 01:07 PDTToolsReplyTeradata TPT ScriptThanks.  Can I also ask, what does the '@jobvar' represent.  Is it just a placeholder for me to put in my dbname, username and password.  Or is it input into the script someh...
2505 May 2014 @ 11:57 PDTToolsReplyTeradata TPT ScriptHey Feinholz, I finally have gotten all the packages installed on my RedHat server.  I know you said to use TPT now for high volume transfer.  I wanted to do it via a perl.  I have c...
2402 May 2014 @ 08:40 PDTToolsReplyFast Export and MLoad Hoping someone can give me guidance.  Currently we have large loads of data being inserted to Teradata via a perl script from Linux RedHat.  The insertion is line by line so it takes hour...
2322 Apr 2014 @ 06:17 PDTToolsReplyTTU Installation on Linux RedHatHow do you become a customer?
2217 Apr 2014 @ 05:56 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1Can you tell me how I can get hold of the TTU download for Linux RedHat?  I've seen a few posts for requests but the only answers I've seen is pointing to documentation about the ...
2116 Apr 2014 @ 12:19 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1Is there a place to download TPT?  I don't see it on the list of downloadable files.  
2016 Apr 2014 @ 07:45 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1I don't have TPT installed.  I installed the following: Teradata ICU, TeraGSS and ODBC pkgs.  Then I installed the DBD::ODBC perl modules to work with DataDirect ODBC Driver Manager....
1916 Apr 2014 @ 07:39 PDTConnectivityReplyDBD::ODBC Connects from command line, not thru crontabI found out the issue is with the LD_LIBRARY_PATH.  I cannot set it within the perl script using: $ENV{LD_LIBRARY_PATH} = '/opt/app/d1car1m6/.perl/usr/lib64'; So I created this entry...
1815 Apr 2014 @ 02:45 PDTToolsReplyfastload error message: Not enough fields in vartext data record number: 1So the older teradata DBD interface, 'DBD::Teradata' was able to do Fastload and MLoad, but not 'DBD::ODBC' ? I am not familiar enough with JAVA, so I would need to run this either...
1715 Apr 2014 @ 10:26 PDTToolsTopicTTU Installation on Linux RedHatCan anyone tell me how I can get hold of the TTU download for Linux RedHat?  I've seen a few posts for requests but the only answers I've seen is pointing to documentation about the in...
1614 Apr 2014 @ 03:41 PDTConnectivityTopicDBD::ODBC Connects from command line, not thru crontabI'm hoping someone can help with this DBI error.  I have installed the perl DBD::ODBC driver into a custom directory and everything works fine when the scripts get kicked off via the comma...

Pages