94 | 02 Jun 2016 @ 08:54 PDT | Teradata Studio | Reply | Password Visible in plaintext History | Are 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.)
|
93 | 02 Jun 2016 @ 06:25 PDT | Database | Reply | Filtering Answerset Issue in SQL Assistant | I 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... |
92 | 01 Jun 2016 @ 08:53 PDT | Aster | Reply | using a variable in aster teradata connectors | It 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... |
91 | 01 Jun 2016 @ 08:44 PDT | Teradata Studio | Reply | Password Visible in plaintext History | I'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... |
90 | 29 May 2016 @ 02:41 PDT | Database | Reply | DATABASE Creation(why db is created from TDA) and why assign dbc as owner and assign perm space,spool space,Temp Space | Anything 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... |
89 | 29 May 2016 @ 02:31 PDT | Tools | Reply | Error locating in SQL Assistant 15 | If 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... |
88 | 29 May 2016 @ 02:22 PDT | Tools | Reply | SQL Assistant - Copy to Notepad | I 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.... |
87 | 29 May 2016 @ 02:15 PDT | Database | Reply | Filtering Answerset Issue in SQL Assistant | I'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... |
86 | 29 May 2016 @ 02:09 PDT | Tools | Reply | Need help in using SQL Assistant | As 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... |
85 | 07 Mar 2016 @ 11:12 PST | Tools | Reply | Teradata SQL Assistant 14 - History Window keeps moving | By '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... |
84 | 26 Oct 2015 @ 01:00 PDT | Teradata Studio | Reply | Comment above REPLACE PROCEDURE causes error | Since 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... |
83 | 26 Oct 2015 @ 12:42 PDT | Teradata Studio | Reply | Teradata Studio Bug | I 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... |
82 | 08 Sep 2015 @ 01:16 PDT | Connectivity | Reply | Result 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... |
81 | 26 Aug 2015 @ 12:09 PDT | Tools | Reply | TTU 15 Installed, SQL Assistant Error | Someone 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... |
80 | 20 Aug 2015 @ 12:16 PDT | Private Forum |
79 | 23 Jul 2015 @ 01:23 PDT | Tools | Reply | Teradata SQL Assistat client connection to SQL databases | The 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... |
78 | 23 Jul 2015 @ 01:13 PDT | Tools | Reply | where 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... |
77 | 23 Jul 2015 @ 01:04 PDT | Tools | Reply | SQL Assistance - Failed to Initialize Error | The 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... |
76 | 13 Apr 2015 @ 08:54 PDT | Tools | Reply | SQL Assistant 13.11.0.05 | FYI. 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... |
75 | 13 Apr 2015 @ 08:49 PDT | Tools | Reply | SQL Assistant 13.11.0.05 | What 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... |
74 | 01 Apr 2015 @ 05:44 PDT | Connectivity | Reply | Where 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... |
73 | 26 Feb 2015 @ 02:26 PST | Tools | Reply | SQL Assistant 15.0 - make row headers selection permanent | I'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.
|
72 | 26 Jan 2015 @ 10:43 PST | Tools | Reply | Teradata 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... |
71 | 14 Jan 2015 @ 12:34 PST | Tools | Reply | Teradata Sql Assistant 14.10 Ctrl + Tab and Ctrl Page Up & Page Down not working | What 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... |
70 | 22 Dec 2014 @ 12:59 PST | Tools | Reply | Teradata Sql Assistant V13.10 error | We 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... |