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!!