#DateForumTypeThreadPost
6924 Aug 2016 @ 12:03 PDTToolsReplyEasyloader Schema Error 15.10 OnlyYou're best Steve!  Once again you came through and I'm so appreciative!  Teradata is lucky to have you and thank you for sticking with this through until the end and providing us...
6824 Aug 2016 @ 11:10 PDTToolsReplyEasyloader Schema Error 15.10 OnlyI guess the issue I'm having if we are moving a flat file to Teradata why doesn't Easy Loader assume all VARCHAR? Does this mean we need to create a job variables files with the proper sch...
6722 Aug 2016 @ 07:16 PDTToolsReplyEasyloader Schema Error 15.10 OnlyHello Steve: Again, sorry about the confusion.  Below is the error and the private log when running under 15.10.  We use the same command line switches for both loads.  I would assu...
6622 Aug 2016 @ 04:16 PDTToolsReplyEasyloader Schema Error 15.10 OnlyThanks Steve:  I think I was sent the incorrect private log.  I'll get back to you as soon as I can with the correct one.  Sorry for the confusion.
6522 Aug 2016 @ 01:36 PDTToolsReplyEasyloader Schema Error 15.10 OnlyOn 15.00 you are correct everything is varchar.  Moving the same file on 15.10 is not. 15.00 Private Log - Success TPT_INFRA: TPT04101: Warning: TMSM failed to initialize Teradata Paralle...
6422 Aug 2016 @ 10:53 PDTToolsReplyEasyloader Schema Error 15.10 OnlySorry about that.  It doesn't work with the new DDL.  We don't have a problem on 15.00 even with the original DDL where there are float columns.  Here is the new test.  ...
6322 Aug 2016 @ 08:09 PDTToolsTopicEasyloader Schema Error 15.10 Only Hello: We're receiving the following error on 15.10 whcih we were not receiving on 15.00.  Could you please help?  Here's our TD Load command line:   tdload -r...
6220 Jun 2016 @ 08:44 PDTToolsReplyEasy Loader Skip Column in Flat FileThank you for the response Steve!  Appreciate your help once again!
6120 Jun 2016 @ 12:09 PDTToolsTopicEasy Loader Skip Column in Flat FileHello: Is there a way to only load specific columns from a flat file using tdload?  Say my flat file has five columns, but I only need the last three.  Is there anyway to specify the fir...
6029 May 2016 @ 10:54 PDTToolsTopicTPT Data StreamsHello: I have a quick clarification on the TPT Architecture. I'm executing a TPT script on my local PC which is using the ODBC Operator to pull data from a non-Teradata data source.  I&#...
5919 Apr 2016 @ 11:33 PDTTeradata Database on AWSReplyQueryGrid Teradata to Hadoop Configuration Issues Thanks for the reply!   This is good advice for those who want to set this up the right way and it makes more sense in hindsight. :P   The whole unknow error thing thre...
5817 Apr 2016 @ 04:31 PDTTeradata Database on AWSReplyQueryGrid Teradata to Hadoop Configuration IssuesA little farther... We can get data using the following syntax. SELECT * FROM SYSLIB.load_from_hcatalog(USING hosttype('hadoop') server('sandbox.hortonwork...
5717 Apr 2016 @ 11:16 PDTTeradata Database on AWSTopicQueryGrid Teradata to Hadoop Configuration IssuesHello: I believe I've installed all the functions in the t2t and t2h directories on Teradata. I'm using the Teradata Base+ instance running on Amazon AWS (single node) I can query a remo...
5616 Oct 2015 @ 09:58 PDTConnectivityReplyODBC driver decimal culture format issueI also saw that I had Region also set to Norway under the Location tab.   1. Go to Control Panel 2. Under "Clock Language and Region" click on the "Change date, time or numb...
5516 Oct 2015 @ 09:39 PDTConnectivityTopicODBC driver decimal culture format issueHello: I'm using the Teradata ODBC driver 15.00.00.01 and testing Norwegian decimal localization in an application.  I created a table with a column with data type decimal(7,2). I inserte...
5409 Jul 2015 @ 03:24 PDTToolsReplyFile Writer operator writing out 0 for decimal columns with precision greater than 18.Thank you Steve!  We're working around this by casting, but it is nice to know that it wasn't something we were doing wrong (which is rare). :P
5308 Jul 2015 @ 07:40 PDTToolsTopicFile Writer operator writing out 0 for decimal columns with precision greater than 18.Hello: When exporting data to a flat file we seeing that decimals with over 18 precision are being returned as zero.  MaxDecimalDigits is set to 38 so is there something else we are doing inc...
5221 Apr 2015 @ 09:39 PDTToolsReplyCalling tbuild.exe directly via command prompt (Windows)As always,  thank you Steve!!!
5120 Apr 2015 @ 04:19 PDTToolsReplyCalling tbuild.exe directly via command prompt (Windows)So the trick is when you have tpt installed, but the tbuild command is not calling TPT is to first try uninstall/reinstall.  If that doesn't work then the next step would be to add the pat...
5017 Apr 2015 @ 01:39 PDTToolsReplyCalling tbuild.exe directly via command prompt (Windows)Hi Martin: Thank you for the reply!   Our batch file is calling tpt the same way using just tbuild.  Our jobs are running fine when we can execute tpt by just type in tbuild.  To d...
4916 Apr 2015 @ 01:04 PDTToolsTopicCalling tbuild.exe directly via command prompt (Windows) Hello:   Sorry. I had posted this earlier, but I accidently unpublished it while looking at it.   We would like to be able to call tbuild.exe directly in a batch file. ...
4816 Apr 2015 @ 12:37 PDTToolsReplyTPT Stream Loader - Create Macro Access error on target database (not working database).So I guess the restart log table's database will be the target database.  Is this correct?  I think it is making more sense now (unless my previous statement is incorrect).  Than...
4713 Apr 2015 @ 04:13 PDTToolsReplyTPT Stream Loader - Create Macro Access error on target database (not working database).Hello Steve: Thank you for the reply! The documentation says "the default macro database is the restart log table database" which I believe is the working database correct?   We h...
4620 Mar 2015 @ 12:35 PDTToolsReplyODBCOperator: TPT17187: Failed to obtain shared memory segment for for column data buffer, due to error 48.Hello Steve:   This fixed the issue.  Thank you so much!
4520 Mar 2015 @ 12:00 PDTToolsTopicTPT Stream Loader - Create Macro Access error on target database (not working database).Hello: When trying to use TPT to stream data from SQL Server we're running into the following error. 'The user does not have CREATE MACRO access to database TargetDatabase'. The Targ...

Pages