All comment activity

#DateUserWhereItemComment
671005 May 2016 @ 07:25 PDTyonakerODBCTeam's blogPHP with Teradata ODBCWe are currently trying to connect to a TD database using PHP.  This page is very useful but I was wondering about the references to ODBC_32.  Can we not use the 64 version?  Also, w...
670905 May 2016 @ 12:46 PDTjosephmichael.navarroToolsTeradata StudioThanks Francine
670804 May 2016 @ 02:41 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressSudheer, Can you open an incident with T@YS so we can collect your error logs and configuration information to look further into this problem? You mentioned using a filter on the data transfer. Is...
670704 May 2016 @ 11:47 PDTSudheer VankayalaToolsTransitioning from SQL Assistant to Studio Expressfgrimmer,If I try giving a filter condition it loads fine. I face the said error when I go for full table refresh(2 million recs). For your question,it happens all the times and am using Teradata S...
670604 May 2016 @ 10:25 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressSudheer, You don't have to configure FastLoad scripts. It uses the JDBC FastLoad option, assuming not column data type issues. The failure above can happen if the database you are loading into...
670504 May 2016 @ 10:20 PDTfgrimmerToolsTeradata StudioAbhishek, The trim is happening in the underlying code of Eclipse used by Result Set Viewer. We are looking for an bug fix or workaround this issue.
670404 May 2016 @ 10:15 PDTSudheer VankayalaToolsTransitioning from SQL Assistant to Studio ExpressAdding to above one,I get the below error. Copy Table Data Task Opening connection... Starting Export... Starting Load... Writing data... Export Error Occurred: Message = Pi...
670304 May 2016 @ 10:14 PDTSudheer VankayalaToolsTransitioning from SQL Assistant to Studio ExpressI can just see a DDL and a SELECT statement from source server(I don't fastload/fastexport scripts). I would need to install any Teradata utilities on my local drive (the drive am running Terad...
670203 May 2016 @ 09:06 PDTAbhishek_RCToolsTeradata Studiohi,  TD studio is trimming spaces in case any field has spaces in the beginning . SQL Assistant does not have this issue.  Example : insert into  DBNAME.test  values ('...
670103 May 2016 @ 09:03 PDTAbhishek_RCToolsTeradata StudioHi,  I am seeing a strange issue with TD Studio 15.10. When i run a select * on a table which has additional spaces in a few fields. TD studio automatically trimming the spaces when in result...
670003 May 2016 @ 03:49 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressSudheer, It will pass the JDBC FASTLOAD option to the JDBC driver for tables with more than 100,000 rows, but if there are column types not supported by the FastLoad protocol, the JDBC driver will ...
669903 May 2016 @ 03:24 PDTSudheer VankayalaToolsTransitioning from SQL Assistant to Studio ExpressHi Fgrimmer, It was a nice article.  I am facing few challenges while exporting/importing huge tables.I noticed that Teradata studio is not using fastexport while exporting the data, it'...
669803 May 2016 @ 08:52 PDTJoergWeidenfeldUDAPhased Rollouts in Unity Director & LoaderHi Paul, thanks for that very helpful article. You know we are just in activation phase of unity at REWE in Germany. Especially the enhancement with 15.00.01 that we can change the managedOn with ...
669702 May 2016 @ 12:03 PDTericscheieToolsTeradata Python Module@privet3711 - Whenever these non-sense error codes/messages come back from the ODBC driver manager, it usually means the Teradata ODBC driver was not found.  This could be either bec...
669602 May 2016 @ 07:33 PDTprivet3711ToolsTeradata Python Module I'm getting this error when trying to connect from linux.  any ideas ?   Traceback (most recent call last):   File "test1.py", line 6, in <module&...
669529 Apr 2016 @ 01:05 PDTsouthsongViewpointAn Overview of the new Viewpoint 15.11 DashboardViewpoint dashboard in 15.11 seem like a very nice feature. Does the rewind feature in viewpoint 15.11 integrate with DSA BAR operations portlet? 
669429 Apr 2016 @ 12:11 PDTMikeDempseyToolsWhat's new in Teradata SQL Assistant 15.0I assume you are refering to Replace All since it would not make sense to move the cursor if you were replacing items one at a time. You did not mention which 'previous' version you were u...
669329 Apr 2016 @ 11:00 PDTkarl_hughesToolsWhat's new in Teradata SQL Assistant 15.0I am using SQLA 15.10.1.3 and when I do a "Find and Replace" the cursor stays at the positions of the last characters that were replaced. Earlier SQLA versions would return the cursor to ...
669229 Apr 2016 @ 09:34 PDTecamagna76ViewpointAn Overview of the new Viewpoint 15.11 DashboardHi, I have a question regarding setting up alerts. Have you considered moving the Alert Action to Alert Setup in Action Sets? I think this is better as the Times is under Action Set Details. We are...
669128 Apr 2016 @ 09:14 PDTcarriecarrie's blogTeradata Basics: ParallelismTeradata Forum has a category called "Data Modeling" which describes itself as:   Discussion topics on Logical Data Models, Physical Data Models, and Semantic Modeling Building ...
669027 Apr 2016 @ 02:18 PDTpreyesdiazcarrie's blogTeradata Basics: ParallelismI am not sure if this is the right place to post this questin , but as is tittled "Basics", here I go.   I need a very simple definition of what a semantic view is. The target popu...
668927 Apr 2016 @ 10:34 PDTMikeDempseyToolsWhat's new in Teradata SQL Assistant 15.0Yes the "* in block comments" issue was fixed in 15.0.0.3 but 15.10.0.1 was completed before that efix was released so the fix was not rolled into 15.10 until 15.10.0.2 I'm afraid. I...
668827 Apr 2016 @ 09:47 PDTzkimbleToolsWhat's new in Teradata SQL Assistant 15.0Hello, I am using SQLA 15.10.0.01, the highest version distributed to users by our DBAs. I keep getting errors from block comments containing *. I thought this was fixed in an earlier version of 1...
668727 Apr 2016 @ 08:38 PDTfgrimmerToolsTransitioning from SQL Assistant to Studio ExpressIt will automatically use JDBC FastLoad option based on the table size.
668627 Apr 2016 @ 04:49 PDTpmatthewODBCTeam's blogPerl with Teradata ODBCHi, I tried to do this tutorial, on a freshly installed CentOS 7, and when I try to connect to Teradata from a perl script, I got the following:  perl: symbol lookup error: /opt/ActivePerl...

Pages