Re: Comma Delimited

On Tue, 25 Jul 2006 20:57:03 GMT, "Shredder" <shred_at_shredder.com> wrote:

>I am forced to use a somewhat generic sql editor that does not allow me to
>save my output to a comma delimited file (CSV). Is there a way to include
>something, in my script, to generate this output with the commas in it?
>

 you may find this is sufficient

spool somefile.csv
set colsep ','
[Quoted] select somedata, somemore, etc
from sometable_at_somedatabase

[Quoted] and this extract will be comma separated.

or you could use this

spool somefile.csv
[Quoted] select somedata, ',', somemore, ',' etc
from sometable_at_somedatabase

Dave Received on Wed Jul 26 2006 - 11:01:16 CEST