#DateForumTypeThreadPost
3413 Jul 2016 @ 02:22 PDTConnectivityReplyOLEDB Driver of TD15.10Thank You Fred... Is there any official reference that you could point me to? I would like to share this with my team.
3313 Jul 2016 @ 11:00 PDTToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colorsI think I found what the issue was. On my system Tab colors are not working when the Application Style is set to "System default" in options->General. I changed it back to Windows...
3212 Jul 2016 @ 10:47 PDTConnectivityTopicOLEDB Driver of TD15.10Are there any plans to release oledb driver for TD 15.10? Because I have SSIS packages that were developed with previous OLEDB version and those SSIS packages are crashing when I open in visual stu...
3112 Jul 2016 @ 09:24 PDTToolsReplyTeradata SQL Assistnat 15.10.1.4: Tab colors I think you misunderstood my question. I am not worried about settings. It is just that tab colors weren't working in the new TDSQLA.  If a query is running in one tab1 an...
3011 Jul 2016 @ 03:30 PDTToolsTopicTeradata SQL Assistnat 15.10.1.4: Tab colorsI am using Sql assistant 15.10.1.4. Tab color is not changing to pink while executing a query Also does not change to green after query completion as we use to have in previous versions. I did chec...
2907 Jul 2016 @ 01:13 PDTToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logThank You Steve
2807 Jul 2016 @ 01:00 PDTToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logI think it is defaulting to 64-bit. Do I need to uninstall 64bit and install 32-bit tpt? I remember it installed both the versions..It is just that I don't know how to run a 32bit version wizar...
2707 Jul 2016 @ 12:39 PDTToolsReplyTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logAlso checked the permissions and I do have full control to the Teradata folder on my C drive. 
2607 Jul 2016 @ 12:34 PDTToolsTopicTPT Wizard 15.10.01.02 64-Bit: error occurred while accessing the logI have installed TD15.10 and using TPT wizard 15.10 to load a file to teradata table. Everything works fine and the job loads the table correctly except that the error messages popping up saying &q...
2528 Feb 2015 @ 11:45 PSTDatabaseReplyQuestion on Aggregated Join IndexThank you Satyanaryana
2426 Feb 2015 @ 06:47 PSTDatabaseTopicQuestion on Aggregated Join IndexI read that it is not recommended to have non-partitioned JI on partitioned base table from a performance point of view. So I have a large table in production with this case. I know I have to ...
2311 Feb 2015 @ 06:22 PSTToolsTopicUnable to load the saved database tree informationSome times I get the error "unable to load the saved database tree information" when I open teradata sql assistant and I loose my saved database tree. My sql assistant version 14.0.0.1 H...
2218 Oct 2014 @ 01:36 PDTDatabaseReplyVolatile Tables in MacrosThanks Dieter... :)
2118 Oct 2014 @ 02:38 PDTDatabaseTopicVolatile Tables in MacrosI am writing a long macro that needed to stage data in several tables before loading into final table. I just learnt that I cannot create more than one volatile table in a macro through error &quo...
2015 Oct 2014 @ 04:11 PDTDatabaseReplySQL-LoopingThank You for your responses Raja_KT and Ulrich. I inserted summaries for each month in to a volatile table and then used union all. In this way I thought I can keep it simple.
1914 Oct 2014 @ 04:02 PDTDatabaseTopicSQL-LoopingHi all, I want to acheive something which I scaled down to below sql, insert into t1 sel 'annual',sum(a) from t2 where EOM_DT between '2013-10-01' and '2014-09-30'; inse...
1821 Sep 2014 @ 10:06 PDTToolsReplyTPT 64bit on Windows 7 sits on FINISH indefinitelyI had similar issue with TPT Wizard. After fixing the java issue using "PATH" variable.I also do not have admin access to my laptop at the time. The issue with not being able to finish tp...
1714 Jul 2014 @ 11:27 PDTDatabaseReplyExecuting several Macros in a MacroYes..I will use Powershell script and will schedule in windows scheduler. We only have a windows server to schedule jobs. 
1611 Jul 2014 @ 01:59 PDTDatabaseReplyExecuting several Macros in a MacroThanks for your response Dieter..That makes sense I thought it would be more clean scheduling wise...so that I can add or remove macros from 1 Master Macro as I want with no work on scheduler job....
1510 Jul 2014 @ 12:15 PDTDatabaseTopicExecuting several Macros in a MacroIs there a difference between executing several macros in one macro instead of executing them individually? When I merge them into one macro I get timeout errors predefined by DBAs where as they e...
1409 Jul 2014 @ 05:39 PDTDatabaseTopicConstraints in TeradataCan we create unique constraint on a partial column? For example: If I have 2 columns in a table with Col1 and Col2. Can I define a constraint on Col1 saying....values of Col1 should be unique on...
1330 Jun 2014 @ 05:15 PDTToolsReplyTPT DSN ErrorThank you for your response Steve. What is the reason for this issue? is it because of 64bit OS? One more question I have is.... Is it a good approach/legal to update tools to latest version even...
1230 Jun 2014 @ 01:01 PDTToolsReplyTPT DSN ErrorUpdate: I have tested the TPT wizard and I am able to export rows into text document with out any issues from a teradata table. It is only exporting zero rows if my source is sql server.
1127 Jun 2014 @ 05:41 PDTToolsTopicTPT DSN ErrorOur enterprise teradata version is 13.10.07.12. I have installed TTU 15 on our 64bit windows server. While trying to use TPT wizard to connect to SQL Server using odbc DSN I am getting Driver ...
1004 Jun 2014 @ 11:23 PDTToolsReplyTeradata Parallel Transporter Wizard 14.10 IssueMy TPT wizard started working in 64 bit environment after following below steps,   1) I have installed latest JRE8 32 bit version    2) Appended "C:\Program Files (x86)\Ja...

Pages