Format other than .CSV while exporting.

sw_flintstone · #1 (**permalink**) 08-31-04, 00:47

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.

sathyaram_s · #2 (**permalink**) 08-31-04, 03:18

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

Internet Services

Web Development

Digital Marketing

Consumer Tech