Re: HOWDOI: Output Variable Length Fields
From: Hayden Worthington, Inc. <hayden_at_mindspring.com>
Date: 1997/01/23
Message-ID: <32E7EFAD.557_at_mindspring.com>#1/1
Date: 1997/01/23
Message-ID: <32E7EFAD.557_at_mindspring.com>#1/1
Eric M. Gamble wrote:
>
> I just tried this method with NO success... Has anyone outputted a
> delimted file? If so, how?...
>
Going to a comma delimited file is really easy. I'm not sure what kind of problems you're having but this little script here works fine!
Give a shot!
set heading off
set trimspool on
spool junk.lst
select rtrim(col1)||','||rtrim(col2)||','||rtrim(col3) from table;
spool off;
Received on Thu Jan 23 1997 - 00:00:00 CET