0 - 50 of 59 tags for sql assistant

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.

I cannot start SQL Assistant, and the error message is:

System.IO.DirectoryNotFoundException: Could not find special directory 'My Documents'.

 

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.
On 32-bit Windows platforms everything is peachy.

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?
Thank you!

(version 14.10 of SQL Assistant)
Is there a bug with this option?
Tools, Options, Query: "Submit only the selected query text, when highlighted" 

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.

 

This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 15.0.
With the exception of a few minor enhancements to support new Teradata Database 15.0 features these changes all relate to the Query window or Query execution.

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.

SQL Assistant - Not able to Define ODBC Data Source through Teradata SQL Assistant v 13.10
I am unable to Define ODBC Data Source in Teradata Sql Assistant.
 
File Not Found
Unexpected Error . Refer to the following file for details :
c:\Users\MYUSERNAME\AppData\Roaming\Teradata\SQL Assistant\SQLAError.txt

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.

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.

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.

 
I installed Teradata V14 for VMWARE on my Windows 7 (64 bit) Machine. Then I installed .Net provider, ODBC driver (Both 64bit and 32bit) on my Windows to Connect Teradata using Teradata SQL Assistant.
But when I try to connect Teradata from SQL Assistant I get the error Teradata Server is not accepting connections.

We've installed the "SQL Assistant 13.10.0.05", but when we want to view the history window this is disabled.
Some web sites told us we need to run the AccessDataBaseEngine.exe and we did it, but It didn't work.
Could you help us with this?
Thanks.

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 :

Hello All,
I have created a dummy table and inserted one record in that table. When i simply select that record it gives me unwanted leading space in the answer set. 

CREATE TABLE dummy (a INTEGER);

INSERT INTO dummy VALUES (986);

 

SELECT '(' || TO_CHAR(a+1) || ')' FROM dummy;

 

Why do views/tables that are no longer found continue to display on my Database Explorer? How can I remove them?

Is there any particular reason that a user's 'Change Password' option would be grayed out in SQL Assistant -> Tools ?

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.

 

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:

Hi Guys,
 
I'm trying to install SQL, but I can not.
it installs Libraries, .Net Data Provider, CLIv2, GSS and ODBC Driver, but not SQL Assistant.
 
Whats going on?

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.

 

This article will describe a few simple features of Teradata SQL Assistant that can help you to create an eye-catching report or email.

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!

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.

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?

 

  

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.

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.

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.

 

 

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.

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.

 

 

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).

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?

 

 

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
Driver Version: Teradata.Net 13.11.0.1
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name: value
at FarPoint.Win.Spread.Model.DefaultSheetAxisModel.SetSize(Int32 index, Int32 value)
at FarPoint.Win.Spread.SheetView.SetColumnWidth(Int32 column, Int32 value)

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"

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?

Hello,

I thought this was covered earlier but could not find in the archives.

This article will introduce the new features and UI enhancements that have been added to Teradata SQL Assistant 13.11. The focus of this release is on usability and Section 508 conformance.

This article assumes that you are already familiar with the features in SQL Assistant 13.10 Edition 2. If not, you may wish to read the following articles first:

Hi Fellow Teradata Developer,

I have a question on how to set Ansi mode on Teradata SQL assistant, I hope you can Shed some light on this.
When I'm working on BTEQ, on the same Database, I run the command .SET TRANSACTION MODE ANSI, and everything seems to work properly. So It's not an issue related with the Database.

I can export some fairly large queries in SQL Assistant JAVA edition, but there appears to be a soft limit somewhere around 20 Meg where it just cuts off and creates an empty file. The results appear to be accurate, the export unwilling.

When we have a SQL statement all on one line, it works fine, but when I add line breaks (for readability) or I import SQL with line breaks, it will throw the following:

[Teradata Database] [TeraJDBC 13.00.00.20] [Error 3706] [SQLState 42000] Syntax error: expected something between the beginning of the request and the 'from' keyword.

This article will introduce the new features and performance enhancements that have been added to Teradata SQL Assistant 13.10 Edition 2. The focus of this release is on usability and performance.

Please see What’s new in Teradata SQL Assistant 13.10 for details of the new features that were added to the original 13.10 release.

HOw could I take an average of two values by arranging the data in ascending order using SQL. For example

For the Col "Var1" with data

TrackId Var1
1 1.2
2 1.1
3 1.5
4 1.6
5 1.3

Could anyone please help me with the Teradata SQL query to "SELECT" all the column name from of a table created into a database which is created in the DBC from example database name: Demo and table name:Temp1.

Teradata SQL Assistant Java Edition release 13.01 is now available for download. SQLA JE provides an information discovery tool for retrieving and displaying data from your Teradata Database systems. It can be run on multiple operating system platforms, such as Windows, Linux, and Mac OSX.

The column headings/titles revert to "A", "B", "C" whenever I begin a query with a comment (for documentation purposes) or perform a join in a query. However, if I remove the leading comment and/or join, the proper titles appear in my answerset.

Hi All,

What version of the Teradata utilities (SQL Assistant, Teradata Administrator, ODBC drivers) will work with a laptop that has Windows 7 installed? Where can I find the correct download site for this?

Thanks!

Paul

Hi,

I'm running Win7 64bit and am connected to a v6.2 Teradata db in SQL Assistant 13.0, however none of the Views or Tables are showing up in the Data Source Explorer. I can query the Views just fine; just can't see them in the tree view.

Any thoughts/suggestions?

Thanks in advance!

This article will introduce the new features and performance enhancements that have been added to Teradata SQL Assistant 13.10. The focus of this release is on usability and performance.