Re: Spooling variable length output

Greg Hayes <greg_at_hayford.demon.co.uk> wrote:

>If I want to spool the output from a select statment to a file
>then I SET LINESIZE 338 let us say. However if the data in the
>file is comma delimited (as in "abcd","defg","","1","sfgdtg"),
>thenthe record is always 338 bytes long instead of 29 as in
>the example above. Does anyone have a soution to this.
>--
>Greg Hayes
>MD
>Hayford Systems Ltd
>+44 71 247 3005 Tel
>+44 71 247 3280 Fax

I ran into the same problem... So I used the didn't use spool. I redirected the sceen output to a file and ran my .sql to put it's output on the screen

for example (in vms)

$ assign/user filename.dat sys$output
$ sqlplus / _at_rpt.sql

where rpt.sql is something like...

set termout off
set linesize.... etc.
set termout on
set show off
select * from emp;
exit;

hope that helps
Jim Donohue
jdonohue_at_usnews.com Received on Wed Nov 15 1995 - 00:00:00 CET