Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    13

    Unanswered: Format other than .CSV while exporting.

    This is the way I exported table data to a flat file.

    EXPORT TO <filename.csv> OF DEL MODIFIED BY COLDEL SELECT * FROM <tablename>

    I am just curious to know whether we can export data in any other format. Like Fixed File Format or Pipe Separatd Values.

    Thanks in advance.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    There are other options like ixf and ASC ... You can use pipe sepearated values by using
    MODIFIED BY COLDEL'|'

    Refer Command Reference or Data Movement Guide for more information

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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