#DateForumTypeThreadPost
9402 Jun 2016 @ 08:54 PDTTeradata StudioReplyPassword Visible in plaintext HistoryAre you maybe using Aster rather than Teradata? That does have a Load_From_Teradata() function, and many others, that take a PASSWORD parameter. (I agree that these need to be masked.)
9302 Jun 2016 @ 06:25 PDTDatabaseReplyFiltering Answerset Issue in SQL AssistantI no longer have 13.10 or 13.11 installed but I verified that 14.01, 14.10, 15.0 and 15.10 all work correctly. (Those are the 4 versions we still support) In addition, filtering was greatly i...
9201 Jun 2016 @ 08:53 PDTAsterReplyusing a variable in aster teradata connectorsIt depends on what app you are using to run your queries. Most apps have a way to specify a variable. For example, in SQL Assistant you would use a 'named parameter' such as ?X. The wher...
9101 Jun 2016 @ 08:44 PDTTeradata StudioReplyPassword Visible in plaintext HistoryI'm a little confused here. There are LOAD_TO_TD and LOAD_FROM_TD functions which the docs say should be used only within a Create Foreign Server statement. (Not called directly from SQL) The...
9029 May 2016 @ 02:41 PDTDatabaseReplyDATABASE Creation(why db is created from TDA) and why assign dbc as owner and assign perm space,spool space,Temp SpaceAnything you can do with TDA you can also do with SQL Assistant. The difference is that TDA forces you to fill in all the required fields when creating a User or Database while SQL Assistant requi...
8929 May 2016 @ 02:31 PDTToolsReplyError locating in SQL Assistant 15If you are referring to SQL syntax errors SQL Assistant will highlight the reported position of the error. This only applies if you use Teradata.net rather than ODBC however. Note that it will onl...
8829 May 2016 @ 02:22 PDTToolsReplySQL Assistant - Copy to NotepadI like the idea of allowing a user to specify which editor to copy to but since the product is capped we are not currently adding new functionality except to support new Teradata Database features....
8729 May 2016 @ 02:15 PDTDatabaseReplyFiltering Answerset Issue in SQL AssistantI'm out of the office at the moment so I'll take a look when I get back in a few days. I don't think I changed anything in that area but it's possible that the spreadsheet vendor c...
8629 May 2016 @ 02:09 PDTToolsReplyNeed help in using SQL AssistantAs Fred stated above you can set a color bar to be displayed across the top of the Query window. Maybe use Red for production and Green for development. If you use Teradata.Net to connect then jus...
8507 Mar 2016 @ 11:12 PSTToolsReplyTeradata SQL Assistant 14 - History Window keeps movingBy 'older' I assume you mean the old VB versions - 12.0 and earlier. .Net does not provide as much control over the z-order of tiled windows so although i added additional code to try to f...
8426 Oct 2015 @ 01:00 PDTTeradata StudioReplyComment above REPLACE PROCEDURE causes errorSince it may be years before the database removes the requirement for a different wire protocol you should handle the issue within TD Studio - as SQLA does. (It looks for this situation and strip...
8326 Oct 2015 @ 12:42 PDTTeradata StudioReplyTeradata Studio BugI had the same issue in SQLA many years ago. I used an internal 32 bit counter. The solution was to remove the counter since I did not have access to a 64bit integer at that time. Now I would have...
8208 Sep 2015 @ 01:16 PDTConnectivityReplyResult sets question on Dot Net provider The results are probably returned as separate result sets so you will need to call NextResult() and loop through all future result sets as well as the first one. (apparently some code is omitted/e...
8126 Aug 2015 @ 12:09 PDTToolsReplyTTU 15 Installed, SQL Assistant ErrorSomeone did confirm that it works OK if you use Teradata.Net instead of ODBC. (This is always recommended anyway) I was also informed that a different user, on the same system, can use the app w...
8020 Aug 2015 @ 12:16 PDTPrivate Forum
7923 Jul 2015 @ 01:23 PDTToolsReplyTeradata SQL Assistat client connection to SQL databasesThe underscore is acting as an ODBC 'wildcard' character. The issue has been fixed in SQL Assistant 15.0.0.2.  Individual efix packages can no longer be downloaded so you will need t...
7823 Jul 2015 @ 01:13 PDTToolsReplywhere is the SQL Assistant option to open all .sql files in a new instance of SQL Assistant?There is no option within the application to open new files in a new instance of the app. There is an option to open new files in a New Query Tab. However it will only create a new tab if you ha...
7723 Jul 2015 @ 01:04 PDTToolsReplySQL Assistance - Failed to Initialize ErrorThe error is being issued by the Microsoft Data Provider Schema Collections initialization function. this implies a problem with the Microsoft .Net Framework itself. If this is only occurring on y...
7613 Apr 2015 @ 08:54 PDTToolsReplySQL Assistant 13.11.0.05FYI. 13.11 is very old now. If you can upgrade to a more recent version it is possible that will help. (I dont think 13.11 was tested with Windows 7) The latest versions of each release are curre...
7513 Apr 2015 @ 08:49 PDTToolsReplySQL Assistant 13.11.0.05What version of SQL Assistant did you upgrade from? (Pre 13.0 maybe?) The most likely causes of a missing History file are: 1) The Directory tab of the Options dialog is pointing to the...
7401 Apr 2015 @ 05:44 PDTConnectivityReplyWhere is SQL Assistant located in TTU 15?I dont understand the question. SQL assistant is on the main TTU 15.0 CD. Or in the TTU 15.0 download bundle.  Just run the main install and you can select SQL Assistant as one of the packag...
7326 Feb 2015 @ 02:26 PSTToolsReplySQL Assistant 15.0 - make row headers selection permanentI'm afraid there is no way to turn them off permanently. We should maybe have provided an option to specify whether headers should be included during copy operations.
7226 Jan 2015 @ 10:43 PSTToolsReplyTeradata SQL Assistant (SQL to highlight columns in results)Tuen is correct. The only highlighting built in to the result sets is the option to display negative numbers in red. You can modify the highlighting in the Query window, or in Explain results, or...
7114 Jan 2015 @ 12:34 PSTToolsReplyTeradata Sql Assistant 14.10 Ctrl + Tab and Ctrl Page Up & Page Down not workingWhat version are you using? I just tried those shortcuts with 14.10.0.8 and they seem to be working fine.  You will find that none of those shortcuts can be specified through the Customize m...
7022 Dec 2014 @ 12:59 PSTToolsReplyTeradata Sql Assistant V13.10 errorWe stopped using ACEDAO a long time ago because there were issues with Microsoft's support for multiple versions [32 vs 64 bit] of MS Office. (they dont allow multiple versions on the same syst...

Pages