HI,

i used the below query in db2 and the result in single coulmn like
102|xxxx|30
103|yyyy|40
after get the above results, i tried to export the file as one.txt. after getting the one.txt files..the content of file like :

"102|xxxx|30"
"103|yyyy|40"

each start and end line i got the double quotes. i want to void the double quotes while export the data into file.


Please help on that issue.



select ' '||COALESCE(employeid,'') || '|'||COALESCE(emaployeename,'') ||'|'|| COALESCE(age,'')||' ' from employee



thanks in advance

Specify "MODIFIED BY nochardel" in your export command.