Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Teradata SQL Analyser display problem

Status
Not open for further replies.

olded

Programmer
Oct 27, 1998
1,065
US
I'm new to Teradata, and I'm having a very strange problem with the Teradata SQL Analyzer. When my SQL DML executes, in the Answerset window instead of displaying the column names it displays alphabet letters.

For example, if I execute:

select col1, col2, col3, col4 from table_name

then in the Answerset pane, the result displays:

A B C D

instead of

col1 col2 col3 col4

And if my query contains 26 columns, then I get every A thru Z.

In the Answerset options I've tried both 'display column titles' and 'display column names'. Neither of them change it.

Thanks for any help.

Ed
 
To fix this problem, I had to unistall and reinstall all of the Teradata software, and I mean all of it. From the Window's Control Panel, I removed these objects:

OLE DB Provider for Teradata 1.5.0.0
ODBC Driver for Teradata 2.6.0.1
Teradata Administrator 7.2
Teradata GSS Client nt-i386 6.2
Teradata SQL Assistant 7.2

before reinstalling.
 
I have seen this happening when there's a comment on top of the select ... ie something like this ..


Code:
-- my comment
SELECT col1, col2
from mytable
;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top