SELECT * not returning all columns

Database
Teradata Employee

SELECT * not returning all columns

I created a table and added a row:

CREATE MULTISET TABLE sales_transaction (
tran_id INTEGER,
tran_date DATE NOT NULL format 'YYYY-MM-DD' DEFAULT DATE '2000-01-01',
customer VARCHAR(100),
amount DECIMAL(18,2)
);

INSERT INTO sales_transaction VALUES (3,'2008-11-26', 'customer', 18.56);

When I do a SELECT * the last column does not appear in the result.  I tried:

.SET WIDTH 100;
.SET RETLIMIT * *;

My result is shown:

SELECT * FROM sales_transaction;

*** Query completed. One row found. 4 columns returned.
*** Total elapsed time was 1 second.

tran_id tran_date customer
----------- ---------- ----------------------------------------------------
3 2008-11-26 customer
1 REPLY
Enthusiast

Re: SELECT * not returning all columns

Bteq used to show the column headers with the same number of characters as defined in column definition.

In ou case Bteq is returning all the columns but the output is being truncated due to command line display limit. 

Here is the solution to your problem:

http://forums.teradata.com/forum/tools/cant-view-all-the-columns-for-a-query-result-in-bteq

Khurram