Exporting Report In BTEQ

[milulove04]

Hi all,

I have a problem when export report in bteq.
This is my code for exporting:

.LOGON
.EXPORT report file=D:\temp.dat;
SET FORMAT OFF;
SET ECHOREQ OFF;
SET TITLEDASHES OFF;
SET HEADING '';
SET RTITLE '';
SET FOOTING '';
SELECT (COUNTRY_CD) || ';' ||(COUNTRY_NAME) ||';' ||(REGION_NAME) ||';' ||(CONTINENT_NAME)
FROM Athena_STG_VOL.COUNTRY_CODES
ORDER BY COUNTRY_CD;
.EXPORT RESET
.LOGOFF
.EXIT

After running this script, I have below export file:

((((((Country_cd||';')||Country_name)||';')||Region_name)||'
AD;Andorra;WESTERN EUROPE;Asia
AE;United Arab Emirates;MIDDLE EAST;Asia
AF;Afghanistan;ASIA;Asia
AG;Antigua and Barbuda;CARIBBEAN;North America

I don't want to appare first line "((((((Country_cd||';')||Country_name)||';')||Region_name)||'" in my file.

Pls help me.

Thanks,
Anthony

 

[al1024]

Just add an empty title to your result column.

SELECT (COUNTRY_CD) || ... ||(CONTINENT_NAME) (TITLE '')
FROM ...