BTEQ Export - suppress column names

Tools
Enthusiast

BTEQ Export - suppress column names

Hi All,

Can someone please help.

I am using BTEQ export (report mode) to get the sum of 4 different products. I want to suppress the column names. tried the below options :

1) used Data mode - the values are not readable but I have to compare the sum using unix script

2) used title('') in the select query but it suppressed only the second column.The query is as follows :select substr(product,1,3),sum(amount)(title'') from table group by substr(product,1,3)

Thanks in advance!!

2 REPLIES
Enthusiast

Re: BTEQ Export - suppress column names

you can use (Title'') after each field selected.

Rglass

Enthusiast

Re: BTEQ Export - suppress column names

thanks!

it worked