Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    12

    Unanswered: Using EXPORT for tab delimited file

    I am not a DB2 person so I'm sure this question is quite trivial, but I'm using the following command:

    EXPORT TO pathname.txt OF DEL

    along with a Select statement that gives me a file like:

    1,2,3,4
    a,b,c,d
    3,2,d,3

    It puts commas between the fields. I need tabs or blanks like:

    1 2 3 4
    a b c d
    3 2 d 3

    Is there an argument or something that I need to supply to get tab delimited vs comma delimited?

    Thanks.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: Using EXPORT for tab delimited file

    Originally posted by unforgiven

    EXPORT TO pathname.txt OF DEL

    along with a Select statement that gives me a file like:

    1,2,3,4
    a,b,c,d
    3,2,d,3

    It puts commas between the fields. I need tabs or blanks like:

    1 2 3 4
    a b c d
    3 2 d 3

    Is there an argument or something that I need to supply to get tab delimited vs comma delimited?

    EXPORT TO ... OF DEL MODIFIED BY COLDEL0x09 SELECT ...

    "COLDEL0x09" specifies column (field) delimiter as the character having hex code of 0x09, which is a tab symbol.

    Nick
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2003
    Posts
    12

    Thumbs up

    THANK YOU! That worked perfect!

Posting Permissions

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