Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    4

    Unanswered: how to avoid the double quotes while Exporting the file in db2

    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

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    Specify "MODIFIED BY nochardel" in your export command.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •