#DateForumTypeThreadPost
2110 May 2015 @ 09:21 PDTTeradata StudioReplyTD Studio 15.10 no driver or connection detailsThanks Chuckbert, the second option worked for me.  I don't even have the drop-down box you describe in the first solution.  Appreciate your help.
2024 Apr 2015 @ 10:33 PDTTeradata StudioTopicTD Studio 15.10 no driver or connection detailsInstalled TD Studio 15.10 and am trying to create a new Connection Profile.  I select Teradata database and then move tto the "Specify a Driver and Connection Details" page, but it&#...
1920 Apr 2015 @ 10:03 PDTDatabaseReplyForce Result Set to Return Column Names and Not Column TitlesAnyone had any luck with this?  Trying to create a Teradata linked server IN MS SQL and but select from views that have column title attributes.
1828 Mar 2014 @ 11:53 PDTToolsReplyEnd of Record marker with TPTThank you, I will perform the upgrade and test again.  If I still have issues I'll send you the log data this weekend.
1727 Mar 2014 @ 12:41 PDTToolsReplyEnd of Record marker with TPTI'm on TPT 14.00.00.06.  log output is below: TPT_INFRA: TPT04101: Warning: TMSM failed to initialize Teradata Parallel Transporter Coordinator Version 14.00.00.06 Teradata Par...
1627 Mar 2014 @ 07:17 PDTToolsReplyEnd of Record marker with TPTThanks, that's what I was thinking.  But I still can't get this to work.  I tried with a test csv that i made in notepad with just a single record and one null column (no space be...
1526 Mar 2014 @ 07:27 PDTToolsReplyEnd of Record marker with TPTThank you Feinholz!  I've traced the issue back to some NULL values in the rows I'm trying to load.  How can I load NULL values using TPT?  I am getting the MAXBUFFERSIZE err...
1418 Mar 2014 @ 09:32 PDTToolsTopicEnd of Record marker with TPTI have a CSV file that I'm attempting to load via TPT.  I have created the CSV file in Excel.  When I try to load the file with the appropriate number of delimiters, I am getting a BU...
1307 Nov 2013 @ 12:16 PSTConnectivityReplyproblem with ODBC drivers SQL assistant not workingTeraJDBC__indep_indep.14.10.00.17 is not necessary In order for the ODBC connector to work correctly you need to have TDICU and the teradata GSS client package installed first.  It's impo...
1207 Nov 2013 @ 12:10 PSTConnectivityReplyODBC and MS Access DSN-less connection VBSorry, should have mentioned that I'm in Access 2010 and using the TD 14.00.0.4 version of the ODBC driver
1107 Nov 2013 @ 12:03 PSTConnectivityTopicODBC and MS Access DSN-less connection VBI have succesfully set up an Access front-end that links tables from a Teradata database.  Everything works fine when I have the tables linked through a DSN.  I am trying to set up a DSN-...
1017 Sep 2013 @ 08:04 PDTConnectivityTopicOracle OleDB Provider with OleLoadHello everyone - I have the Oracle 11g client and components installed but the Oracle OleDB Provider will not show up in the list of options in the OleLoad tool.  I have manually registered th...
931 Jul 2013 @ 11:38 PDTToolsReplyTPT load Varchar(MAX) LOB from SQL Server to TeradataAnyone who finds this, I've found out that TPT currently only supports loading LOB's from flat files.
830 Jul 2013 @ 12:46 PDTToolsReplyTPT load Varchar(MAX) LOB from SQL Server to TeradataTried deferred loading using this script: USING CHAR SET UTF8 DEFINE JOB MyJob ( DEFINE SCHEMA MySchema ( Network INTEGER, Activity SMALLINT, Element ...
730 Jul 2013 @ 11:22 PDTToolsReplyTPT load Varchar(MAX) LOB from SQL Server to TeradataJust found this (right after i posted....) http://developer.teradata.com/tools/articles/large-object-loading-with-teradata-parallel-transporter will try defferred loading and will report back
630 Jul 2013 @ 11:11 PDTToolsTopicTPT load Varchar(MAX) LOB from SQL Server to TeradataHi everyone.  I'm trying to load SQL server tables to Teradata14 using OleDB via TD's OleLoad tool.  I'm having trouble with attributes defined as VARCHAR(MAX) in SQL server -...
519 Jun 2013 @ 08:13 PDTDatabaseReplyPrecision loss during expression evaluation - data type issue?Thanks for your help! The data profile is true to the data type.  MVT_Gravity is the specific gravity of a substance so I need to take that all the way to 6 decimal places.   MAX net_qu...
418 Jun 2013 @ 10:26 PDTDatabaseTopicPrecision loss during expression evaluation - data type issue?Hi, when I execute the following SQL sel doc_id , prd_id , prd_cmn_name , net_quant , mvt_gravity , cast(net_quant*42*(mvt_gravity*8.338426855)-0.0101578 as DECIMAL(19,13)) from monr...
305 Jun 2013 @ 06:26 PDTDatabaseReplyMERGE...WHEN NOT MATCHED INSERT into 2 separate tablesthanks dieter, I appreciate the response.  I started with Teradata in 2011, and you are sort of a legend - I remember using your view that reverse-engineers "collect statistics" stat...
204 Jun 2013 @ 06:53 PDTDatabaseTopicMERGE...WHEN NOT MATCHED INSERT into 2 separate tablesIs there any way to have a MERGE INTO statement insert rows into 2 separate tables?  In the example below, t3 is a work table that will hold the value of :a when the WHEN MATCHED condition is ...
105 Nov 2012 @ 09:29 PSTDatabaseTopicExternal UDF for strtok function in 13.10?Hi, I'm looking for an external UDF that will emulate the strtok function in C.  I'm aware that it is available as an internal function on TD14, but our client is running 13.10.  ...