Re: export Data as Text ?
Date: 2000/08/08
Message-ID: <sp1pfe2j63a52_at_corp.supernews.com>#1/1
"Frank Langelage" <langel_at_st-oneline.de> wrote in message
news:399069D4.B2BBB850_at_st-oneline.de...
> Which tools are free available to export Tabledata (Server 7.3.4) as an
> csv-File (ascii-text, field values of variable length separated by an
> delimiter) ?
You can do it yourself (assume a delimiter of a tilde in this example):
set linesize <some large number>
set trimspool on
set echo off
set pagesize 0
set feedback off
set heading off
select col1||'~'||col2||'~'||col3 (etc...)
from mytable
where...
set termout off
spool myfile.csv
/
spool off
The only thing you'll need to clean up afterwards is you'll have one line with your prompt and a "/" on it at the beginning of the file.
-Matt Received on Tue Aug 08 2000 - 00:00:00 CEST