Re: How do we do an ascii dump of a table with a delimiter ?
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/05/04
Message-ID: <3obkcg$hov_at_ixnews3.ix.netcom.com>#1/1
Date: 1995/05/04
Message-ID: <3obkcg$hov_at_ixnews3.ix.netcom.com>#1/1
In <3o8djo$a13_at_news1.cle.ab.com> Raghid Ajamoughli
>you may want to try the following
>
>set pagesize 0
>set linesize 1000
>spool filename
>
>select col1, ',', col2, ',', col3, ',', col4 ...
>from your table;
>
>spool off
>
>this will output the table into filename on your system.
>hope this helps
Suppose you want to use TAB as the delimiter?
--Received on Thu May 04 1995 - 00:00:00 CEST
><> Chuck Hamilton <><
><> chuckh_at_ix.netcom.com <><