Pages
![]() |
1. You need to change the dbc password by running tdc-start to enable port 1025 which is used by ODBC and CLI connections
31 Mar 2016
| 2 comments
,
|
![]() |
I am using SQL Assistant 14.10.0.02, and i want to change settings for multiple answerset. Currently its opening in multiple tiles, making 4 tiles - 1 for Query,1 for History and 2 for Answerset(more depend on queries). How can we merge Answer set in one tile with multiple Tabs, the way multiple Query window works. Please guide.
21 Jan 2016
| 3 comments
,
|
![]() |
Hello all -
05 Dec 2015
| 1 comment
,
|
![]() |
Good Afternoon All,
09 Nov 2015
| 1 comment
,
|
![]() |
Hi,
09 Nov 2015
| 2 comments
,
|
![]() |
You know how SQL Assistant will display a hyperlink in the answerset grid for BLOBs and CLOBs? Is there any way to do that yourself? I have file locations stored in a table in a VARCHAR column like "\\servername\foldername\MyFileName.txt". Any way to get SQL Assistant to display it a
24 Sep 2015
,
|
![]() |
I've upgraded to Teradata SQL Assistanct to 14.01. I'm getting a "system failed to initialize" error. I can run sql but can't view the db tree. Found this in an old post but the solution of deleted the dbtree.config did not work. Any help would be greatly appreciated.
22 Jul 2015
| 1 comment
,
|
![]() |
This article is intended to help users as they transition from Teradata SQL Assistant to Teradata Studio Express. Included are some of the more frequently used SQL Assistant features along with a detailed 'How To' guide for the same features in Studio Express. Note: this article is relevant for Studio Express 15.10 or later.
22 Apr 2015
| 78 comments
,
|
![]() |
If I wanted to suggest some new features for SQL Assistant, where would one go?
19 Feb 2015
| 1 comment
,
|
![]() |
Some times I get the error "unable to load the saved database tree information" when I open teradata sql assistant and I loose my saved database tree. My sql assistant version 14.0.0.1
11 Feb 2015
,
|
![]() |
Hi,
28 Jan 2015
,
|
![]() |
Hi there,
19 Jan 2015
,
|
![]() |
Hello,
15 Jan 2015
,
|
![]() |
Can anyone tell me where the favorites are stored? I am using two instances of SQL Assistant (one on laptop, one on VM) and would like to merge both.
28 Oct 2014
| 1 comment
,
|
![]() |
I cannot start SQL Assistant, and the error message is: System.IO.DirectoryNotFoundException: Could not find special directory 'My Documents'.
26 Aug 2014
| 5 comments
,
|
![]() |
Since it appears SQL Assistant is still available only in 32-bit version (TD 14/15 clients), it attempts to connect to Oracle's 32-bit ODBC.
13 Aug 2014
| 4 comments
,
|
![]() |
Would like to know if it is possible to show tablenames in mixed case (i.e., MixedCase instead of MIXEDCASE) in the Database Explorer window. If so, where and how is this option set?
22 Jul 2014
| 2 comments
,
|
![]() |
(version 14.10 of SQL Assistant)
11 Jul 2014
| 1 comment
,
|
![]() |
Teradata Studio Express 15.00 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.
28 Apr 2014
| 88 comments
,
|
![]() |
This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 15.0.
14 Apr 2014
| 67 comments
,
|
![]() |
It has become very slow fetching an answer set (serval seconds per row) during last several days using Teradata SQL Assistant. I never experienced this problem before. Rebooting the computer does not help. People use Teradata SQL Assistant in our office pritty intensively, but no one has ever experienced this problem. Please help.
14 Mar 2014
| 3 comments
,
|
![]() |
SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10
28 Jan 2014
| 2 comments
,
|
![]() |
I've recently begun working with Teradata Studio Express after about a year of working with SQL Assistant. My primary use of Teradata is for BI applications such as ad-hoc reporting.
16 Jan 2014
| 9 comments
,
|
![]() |
This may seem like a trivial matter, and it certainly doeesn't prevent me from doing my job, but I thought I'd ask anyway. I was recently upgraded from my super old and comfy version of SQL Assistant to V 13.11. Since the upgrade, when I paste my code into the query window, the scoll button on my mouse no longer functions.
07 Nov 2013
| 2 comments
,
|
![]() |
Teradata Studio Express 14.10.01 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.
29 Oct 2013
| 8 comments
,
|
![]() |
07 Oct 2013
,
|
![]() |
We've installed the "SQL Assistant 13.10.0.05", but when we want to view the history window this is disabled.
26 Sep 2013
| 1 comment
,
|
![]() |
Hi All,
I am using SQL Assistant as my workbench for TERADATA. Recently, my system crashed and i had to setup the SQL assistant again. SQL history was available in a MS Access DB file and i was able to save a lot of time as i had backed it up earlier.
However, i had a tough time with the following :
16 Sep 2013
| 5 comments
,
|
![]() |
Hello All, CREATE TABLE dummy (a INTEGER); INSERT INTO dummy VALUES (986);
SELECT '(' || TO_CHAR(a+1) || ')' FROM dummy;
05 Sep 2013
| 8 comments
,
|
![]() |
Why do views/tables that are no longer found continue to display on my Database Explorer? How can I remove them?
22 Aug 2013
,
|
![]() |
Is there any particular reason that a user's 'Change Password' option would be grayed out in SQL Assistant -> Tools ?
22 Aug 2013
| 1 comment
,
|
![]() |
Teradata Studio Express 14.10 is now available for download. Teradata Studio Express is an information discovery tool for retrieving and displaying data from your Teradata Database systems.
16 Aug 2013
| 71 comments
,
|
![]() |
This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 14.10, and highlight some existing but lesser known features. This article assumes that you are already familiar with the features in SQL Assistant 14.01. If not, you may wish to read the following articles first:
09 Aug 2013
| 15 comments
,
|
![]() |
Hi Guys,
29 May 2013
,
|
![]() |
I currently use SQL Assistant to write Teradata tables to existing MS Access tables by using the SQL Assistant "Export Results" File option. The problem is that I must manually direct the output to the specific table in SQL Assistant and there are 30 tables that I need to reload each month.
26 Mar 2013
| 2 comments
,
|
![]() |
This article will describe a few simple features of Teradata SQL Assistant that can help you to create an eye-catching report or email.
20 Dec 2012
| 3 comments
,
|
![]() |
|
![]() |
I am trying to import some data and it keeps giving me a format error. Is this because I am not including the column headers? Thanks for the help!
20 Jun 2012
| 1 comment
,
|
![]() |
I use SQL Assistant to connect to DB2 databases on the z/OS platform (in addition to using it for Teradata, SQL Server, and Oracle). In some of our DB2 databases, user access to tables is provided via alias instead of views. Trouble is, SQL Assistant does not show aliases when expanding a DB2 database.
19 Jun 2012
,
|
![]() |
Does Teradata capture the response time that it takes when a user opens the metadata within Teradata's SQL Assistant's Database Explore? Secondly, can Teradata be tuned to get better responses to these Database Explorer queries?
25 Apr 2012
| 1 comment
,
|
![]() |
This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 14.01. The focus of this release is on usability and the introduction of Charting and the direct editing of Table data.
09 Mar 2012
| 21 comments
,
|
![]() |
Upgraded SQL Assistant JE to Studio Express and everything is great until I try and copy text from the Scrapbook. At which point I find out that "Copy" is bound to "Ctrl+Insert". I scramble to the preferences to change the binding and find out that "Copy" is bound to both "Ctrl+Insert" and "Ctrl+C" but unfortunately the latter doesn't work.
28 Feb 2012
| 1 comment
,
|
![]() |
Is there going to be a release of SQL Assistant that can be installed on Windows 7 64bit? The Java version doesn't work very quickly and is cumbersome to use.
13 Feb 2012
| 2 comments
,
|
![]() |
When using BTEQ or SQL Assitant to upload data into tables, I'm only getting about 2 records per second speed. Unfortunately, I don't have access to Fastload. I know its not the network as my down speed is blazing and Oracle is uploading normally.
01 Feb 2012
| 11 comments
,
|
![]() |
I have installed Teradata 13.0 express edition under OS Window7, but unable locate SQL Assistant program. Try to search at C:\Program Files\Teradata\Client\13.0\, not file/folder name by SQL Assistant.
17 Jan 2012
,
|
![]() |
Teradata Studio Express is an information discovery tool that retrieves data from Teradata and Aster Database systems and allows the data to be manipulated and stored on the desktop. It is built on top of the Eclipse Rich Client Platform (RCP).
14 Dec 2011
| 178 comments
,
|
![]() |
There is 2 options that i really misses in the Setup under "Tools -> Options - > History". 1) Save only successfull queries. 2) Do not save Explain. Any possibilities for getting these one's?
09 Nov 2011
| 3 comments
,
|
![]() |
Anyone know why I would be getting the below error during query execution? I'm assuming it has something to do with the grid that it is trying to populate with the results from the query. SQLA Version: 13.10.0.7
16 Aug 2011
| 7 comments
,
|
![]() |
I am using Teradata 12 SQL Assistant, In status bar most of the time I am getting some numbers which are not relevant to the command which I have executed successfully. Like I have a table with single column and 2 records. When I drop the table, The status will be like " Completed, 15 Rows Processed"
10 Aug 2011
| 1 comment
,
|
![]() |
SQLA JE 13.11 on Vista does not want to run as a normal user account. It will run under a local admin account, but when run as a normal user it just hangs on the splash screen. Any ideas?
23 Jul 2011
| 5 comments
,
|