Unanswered: how to avoid the double quotes while Exporting the file in db2
i used the below query in db2 and the result in single coulmn like
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 :
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