#DateForumTypeThreadPost
1908 Feb 2011 @ 08:18 PSTToolsReplyCompatability Of TTU12 Administrator And Teradata 13.0You can make the TTU 12 versdion work by editing the winddi.def file (in the \sql sub-directory) If you will ONLY be working with TD 13.0 (not 12.0) then you can simply change the first line of ...
1807 Dec 2010 @ 06:36 PSTToolsReplySQL Assistant Keyboard Shortcut to switch between QueriesThere are no shortcits in the current version of SQLA. However the next version (13.11) will implement support for Section 508 UI requirements. One of these is the ability use the keyboard for all...
1722 Nov 2010 @ 05:46 PSTGeneralReplySQL Assistant Install on VistaI think this is the issue where it fails if .Net Framework 4 is installed. The install package originally looked specifically for version 2. We changed the install in efix 13.0.0.10 so that it wo...
1629 Oct 2010 @ 07:52 PDTGeneralReplyClipboard issues with Teradata SQL Assistant 12 in Citrix Based on the above comments these are 2 different problems. In the 12.0 case copy/paste within SQLA is working, and copy from SQLA to another app is working. Only the copy from another app to SQLA...
1520 Aug 2010 @ 11:13 PDTConnectivityReplySQL Assistant => Oracle Timestamp ProblemSQL Assistant 12.0 was a VB app that directly calls the ODBC API. As a result it was able to support everything that ODBC supports. SQL Assistant 13.0 is a Microsoft .Net application which acces...
1428 Jun 2010 @ 11:23 PDTToolsReplyNo Views or Tables in SQL Assistant 13.0As mentioned above there are 2 sets of dictionary views, and you may not have access to both. If you use Teradata.Net to connect you can set the 'Use X views' checkbox on the Advanced tab of the c...
1328 Jun 2010 @ 11:15 PDTToolsReplySQL Assistant: Disappearing Answerset HeadersThe "A", "B", "C" headings are displayed when ODBC returns no column titles. I think this problem has been fixed in a later version of the ODBC driver. (I know a similar case of empty headings wa...
1228 Jun 2010 @ 11:00 PDTToolsReplySQL Assistant 13 won't run second queryI thought I had added a reply back in Feb ... but I guess not. We did have a couple of situations in which the query would appear to hang in earlier versions of SQLA 13.0, but those were fixed in ...
1113 Apr 2010 @ 07:17 PDTToolsReplyWindows 7 & SQL Assistant/Teradata AdministratorYou can download the latest efix from the patch server. I think this will require a T@YS account. Alternatively you can use the TTU 13 CDs (Edition 2) but that wil not give you the latest patch r...
1018 Mar 2010 @ 06:40 PDTToolsReplySQL Assistant 13There are no plans to implement a hierachical view of databases in the Explorer pane. Partly because few databases vendors have any concept of hierachy, and partly because most business users dont ...
918 Mar 2010 @ 06:30 PDTToolsReplyWindows 7 & SQL Assistant/Teradata AdministratorThe (near) future release of TTU 13.10 has been fully tested on Windows 7. We have also done limited testing with 13.0 and I am not aware of any problems there either. Versions prior to 13.0 will...
818 Mar 2010 @ 05:55 PDTToolsReplySQL Assistant 13 Explorer View doesn't show all tablesThe "Use alternate schema..." option applies only to 'unknown' databases. That is vendors whose databases we do not provide any specific support for. We have specific support for SQL Server. The...
702 Feb 2010 @ 06:49 PSTToolsReplyStartup parameters for SQL Assistant V13.0The default for the connection type is initially ODBC. However the connection type will be remembered based on the last value you set it to. When using command line parameters it will use the con...
627 Jan 2010 @ 01:25 PSTViewpointReplyWhat Teradata products would you like to see in Viewpoint?If you are wanting to access the database used to store Viewpoint data there are many query tools (including SQL Assistant) that can be used to do that. While SQL Assistant 12 was never tested agai...
525 Nov 2009 @ 07:14 PSTToolsReplySQLA 13.0.0.7 Tera Express 13We have not done any testing with SQLA 13 on Win7. We are currently testing SQLA 13.10 (available Q1 2010) on Win7 and have not found any problems so far. (Note that we are using the final releas...
416 Mar 2009 @ 01:31 PDTToolsReplyminor bug in SQL assistant with multiple queries enabledI assume you are using version 12.0 or earlier.It is true that older versions remember only the most recently opened/saved file, so if you work with files you need to be aware of this.(Many people ...
305 Sep 2008 @ 01:35 PDTDatabaseReplyTeradata Assistant BugThis sounds like DR106220 which was fixed in 7.2.0.1.Please download the latest efix for 7.2 from the patch server. (version 7.2.0.9)Note that the problem only occurs when your child windows are ma...
205 Oct 2006 @ 02:38 PDTAnalyticsReplyTeradata SQL assistant: limiting the number of rows returned in "Export results"There is currently no way to limit the # rows returned by an Export in SQL Assistant.There are only 2 options here:1) Add the clause 'TOP 50' after the Select keyword in each of your statements. (N...
105 Oct 2006 @ 02:07 PDTToolsReplyTeradata Administrator optionsNo there is no tool to perform Alter Table commands.There are so many possibilities with Alter Table that it would require a whole set of complex dialogs to navigate through.The result is that it w...

Pages