#DateForumTypeThreadPost
5130 Jun 2015 @ 06:33 PDTToolsTopicInstalling TTUI have tried several times to download and install the TTU software from the Download page.  Eeverytime I get a message the SQL Assistant did not install properly.  What am I missing?&nbs...
5009 Dec 2014 @ 01:21 PSTToolsTopicSQL Assistant install errorHello, I have downloaded the TTU 15 For Windows zip file from the downloads page.  After unzipping, all the components installed properly EXCEPT SQL Assistant.  I downloaded the .zip fil...
4911 Apr 2013 @ 02:00 PDTViewpointTopicViewpoint CompatabilityWhat is the minimum version of Viewpoint that is compatable with the Database 14.0?   Thanks!   Paul
4819 Jun 2012 @ 02:50 PDTConnectivityReplySocket Error 804 Thanks Tom,   I will pass this info onto to our 3rd Party support team to see if this helps them with this issue.   Paul
4718 Jun 2012 @ 01:01 PDTConnectivityReplySocket Error 804 Thanks for the replies.  This is a process being run by a 3rd Party company supporting a Teradata process.  This error has occurred every night that they have tried to run the process....
4615 Jun 2012 @ 01:10 PDTConnectivityTopicSocket Error 804 Does anyone know what would cause, or how to correct a Socket Error?  Below are the details of the error message: "CAMSPROD","Error Executing Database Query.[Teradata JDB...
4511 Apr 2012 @ 08:01 PDTViewpointTopicViewpoint and DBQL logs Hi,   Can Viewpoint be used to produce a readable report from the DBQL logs, or is this something that needs to be done using basic SQL?   Thanks!
4407 Feb 2012 @ 08:20 PSTViewpointTopicNo Data in Query Monitor I have an issue that I cannot figure out.  In Viewpoint, my Query Monitor session shows no data.  DBQL is turned on.  What other features in ViewPoint or Teradata need to be turne...
4317 May 2011 @ 09:02 PDTDatabaseTopicSQL Color resultsIs there a way in SQL to return data values in a particular color depending on some logic? Something like Green if everything is "normal", Yellow if values are slightly out of bounds and Red if va...
4211 May 2011 @ 01:51 PDTThird Party SoftwareTopicSPSS/ClementineCurrently SPSS/Clementine is installed to operate against our Teradata system, and when I check the DBQL logs to review who is doing what, I see that the user Clementine is running SQL. This user ...
4129 Apr 2011 @ 12:24 PDTDatabaseTopicAccess Logging QuestionHello, I have turned Access Loging on for some of our databases. Using Teradata Administrator to do this, I saw some options I am not really sure what they are for, and hoped someone here could...
4020 Apr 2011 @ 08:31 PDTGeneralTopicMove a subset of RecordsHello, I am trying to set up our Development environment, and would like to take a copy of the Production envirnment and put in in Dev. The catch....I don't want 100% of all records in the tabl...
3929 Mar 2011 @ 10:27 PDTToolsTopicSQL Assistant truncating View definitionHello, I thought this was covered earlier but could not find in the archives. When I use SQL Assistnat to "show definition" of a very large View, part of the view is displayed and the remaind...
3823 Mar 2011 @ 10:01 PDTToolsTopicOle Load problem Version 13.1Hello, My site recently upgraded to the TTU version 13.1 Trying to set up Ole Load, I am encountering a problem, which I could use some help with. I am able to access the source data (which ...
3722 Mar 2011 @ 07:57 PDTThird Party SoftwareTopicMoving Data from SQL Server to TeradataHi, I'm not sure if I posted this in the right forum, but here goes. I need to load (basically copy) tables from a SQL Server application and load those tables to Teradata. I can access the ...
3610 Mar 2011 @ 10:40 PSTToolsReplyTTU 13.1Thanks Dieter!
3510 Mar 2011 @ 07:15 PSTToolsTopicTTU 13.1Hi, I am in the process of upgrading my client's desktops to the TTU 13.1 version. Does PMON (Performance Monitor) still exist with this version? I could not find it in the utilities. If PM...
3425 Jan 2011 @ 01:04 PSTDatabaseTopicDatabase Access Logging/ReportingHi All, Is there a way to track users who access a particular database in the data warehouse? Would this be done thru the DBQL? Are there any "standard" sql reports that exist for this kind of...
3317 Aug 2010 @ 10:55 PDTToolsTopicRetain Previous record field valueHello, I have a file that contains a Employer record ("M"), followed by multiple Employee records ("B"). There is nothing in the Employee record that ties it to the Employer record other than t...
3230 Jul 2010 @ 10:47 PDTToolsTopicLoading XML dataHi All, Is there a way I can load output from a XML process into Teradata? This is new ground for me, so I have no clue how to even start looking for a solution. Thanks! Paul
3108 Jul 2010 @ 06:08 PDTDatabaseReplyCreating a PercentageThanks Dieter! That worked great! It was driving me crazy trying to figure out this issue, which is relativly simple. Paul
3007 Jul 2010 @ 08:04 PDTDatabaseTopicCreating a PercentageHello, I am really missing something here, and I hope someone can help me. I am simply trying to divide two numbers, and end up with a percentage. All I get as a result is 1.0000000 Here is...
2920 May 2010 @ 11:20 PDTToolsReplyV12 TTU Install confusionAs an add-on to this question.....more background information. The client site has not done a good job keeping up with Windows upgrades. What is the low-end of Windows/products (Access, etc) th...
2820 May 2010 @ 10:53 PDTToolsTopicV12 TTU Install confusionHello, I am dealing with a very stragnge situation that I hope someone can explain. We recently upgraded to a V12 Teradata machine at our client site. We are now trying to install the V12 TTU ...
2729 Apr 2010 @ 07:57 PDTDatabaseTopicMaxParseTreeSegHow/where do I change the value of the MaxParseTreeSeg? We recently upgraded our system, and while testing had several jobs fail with an "Insuffiecient Memory" error. Research has said to increas...

Pages