#DateForumTypeThreadPost
4407 Feb 2013 @ 07:21 PSTToolsReplySQL Assistant 13 not importing from txt file saved from Excel Are you using ODBC or Teradata.Net to connect? What exact version of SQL Assistant are you using? Could you send a small sample input file to Mike.Dempsey@Teradata.com so that I can try to replic...
4307 Feb 2013 @ 07:10 PSTToolsReplysql assistant 13.10 - Show definition window wont closeThis bug was introduced in 13.10.0.6 when we fixed a related problem. It was corrected in 13.10.0.8. I would suggest you update to the latest release. That would be 13.10.0.9 or [better] 13...
4215 Oct 2012 @ 10:47 PDTConnectivityReplyDAO Error When Exporting To MS AccessVersions 13.10.0.0 thru 13.10.0.6 used the Microsoft Office Access Engine dll to support the Export to Access function. Unfortunately Microsoft designed that dll in such a way that only one versio...
4127 Jul 2012 @ 06:00 PDTToolsReplyMacro problem in SQL Assistant 13.0 If you are using SQL Assistant 13.11 or higher there is a new tool button that will allow you to delete macros. If you are using an older version the only way to delete them is to delete the...
4010 Jul 2012 @ 10:48 PDTGeneralReplySQLA 13.11 Command Line Question That is by design. The idea of a 'batch' execution is that there is no user. If you click on the application it realizes that there IS a user and automatically switches back to stand...
3914 Jun 2012 @ 12:58 PDTConnectivityReplyProblem with teradata SQLA 13 'object reference not set' That looks like DR 149709 which was fixed in 13.10.0.5. (about 15 months ago) I would strongly recommend checking the Teradata Software Server before installing any new version of software s...
3811 Jun 2012 @ 01:40 PDTToolsReplyStartup Parameter to export to MS Access? Sorry, it appears that part of the description of the -e parameter is missing from the version 12.0 user guide. The following is from a later version but applies to 12.0 as well. For Exp...
3711 Jun 2012 @ 01:31 PDTToolsReplyMechanisms to connect into the Teradata SQL assistant The mechanisms depend on which data provider you use (.Net Data Provider for Teradata or ODBC) and on what version of those products you are using. For Teradata.Net it would be:  &nbs...
3611 Jun 2012 @ 01:26 PDTToolsReplyQueryman and SQLA as APPID in DBQL Versions up to and including 12.0 would be recorded as Queryman. Version 13.0 and later will be recorded as SQLA. (I'm assuming you are refering to the application name field in the ...
3511 Jun 2012 @ 09:27 PDTToolsReplySQL Assistant: System.ArgumentOutOfRangeException SQLA 13.x uses completely different code to set the column widths, and that code varies depending on the data type/size. The only way I have been able to reproduce this problem is if th...
3406 Jun 2012 @ 01:59 PDTToolsReplySQL Assistant: System.ArgumentOutOfRangeException This problem depends on the data type of the column it is trying to size. I would need to know the definition of the columns returned by the query, the column titles [if different fr...
3301 Jun 2012 @ 08:23 PDTToolsReplyError Starting SQL Assistant v13.10 'My Documents' is a special directory that should always exist on a Windows system. (The actual name may not be 'My Documents' as that is fetched using a Windows API function.) ...
3201 Jun 2012 @ 08:15 PDTGeneralReplyStartup Export Parameter Issues I don't see anything wrong with the syntax - substituting my own file names and DSN works fine. As a general rule I would enclose filenames in double quotes just in case they contain spa...
3101 Jun 2012 @ 07:34 PDTToolsReplySQL Assistant "show table" results and other things truncated Send the above to mike.dempsey@teradata.com
3001 Jun 2012 @ 07:33 PDTToolsReplySQL Assistant "show table" results and other things truncated The problem with SHOW TABLE has been answered but I'm interested in the other case. You say you copied the 91 statements from 'another window'. Is this from another Query windo...
2931 May 2012 @ 12:00 PDTConnectivityReplyInstall Teradata SQL Assistant First of all SQL Assistant (all versions) is a 32 bit application. That said, you should be able to install it on a 64 bit Windows system as it will use the 'WOW' (Windows on Wind...
2830 May 2012 @ 08:14 PDTToolsReplySQL Assistant 13 - DB2 - Char values displayed as nulls There must be some special conditions here. I am able to retrieve CHAR data (both VARCHAR and CHAR) without any problem. Can you give me some more details. Which version of SQLA are yo...
2702 Mar 2012 @ 01:04 PSTToolsReplySQL Assistant 12 comment italics You can edit the file terada.lng (in the same directory as the executable. Look for the line:  <tokenset name="Block Comments" id="blockcomments" type="s...
2620 Jan 2012 @ 05:46 PSTToolsReplyReconnect Error Message That message is comming directly from the ODBC driver. Recent versions of the driver have been changed so that they no longer issue messages. If you upgrade to the latest version the message...
2515 Dec 2011 @ 01:03 PSTGeneralReplyTeradata SQL assistance for MICROSOFT Code Completion What version of SQL assistant are you using? thisfeature was added in 13.11. If you have an older version it will not be available.
2418 Aug 2011 @ 11:24 PDTToolsReplySQL Assistant: System.ArgumentOutOfRangeExceptionCan you reproduce this problem? If so can you send me the SQL (or a stripped down version that still exhibits the problem) together with any Table/View definitions I would need to recreate it. Se...
2315 Jul 2011 @ 03:44 PDTDatabaseReplyExecuting a multi-statement requestAs usual, Dieter is correct. I was not aware of this limitation. Now that i am I have devised a workaround that I will implement in the next efixs. (That would be 13.0.0.16 and 13.11.0.3)
2225 Apr 2011 @ 12:36 PDTToolsReplySQL Assistant 13 not displaying historyHave you verified that the ShowHistory menu (on View) is checked? Check it if it is not. If it is already checked, please try the following. Go to the execution directory and execute verify.ex...
2116 Feb 2011 @ 06:16 PSTToolsReplyconfiguration system failed to initialize after upgrading to sql assistant 13.10There is no such message in SQL Assistant so it must be comming from either the .Net Framework or one of the third parety tools we use. Since this is the Database Tree try deleting the file "DBT...
2009 Feb 2011 @ 02:52 PSTToolsReply Can't install SQL Assistant 13.0.0.3I think the problem is that you have .Net Framework 4.0. Our older install scripts do not allow for 4.0, only 2.0 thru 3.5. We fixed this problem in SQLA 13.10.0.1 (latest is 13.10.0.4) and i...

Pages