If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

spool file without blank line

Hi,

I want to spool a query result without heading, title and the blank line in a text file, but no matter what I tried,use "space 0, newspace 0", there is alwasy a blank line between the content and the top border in the spool file, can anyone have good idea to get rid of it?
Thank you!

What I wrote -
"set heading off;
set space 0;
spool result.txt;
select id, name from emp;
spool off;
set space 1;
set heading on;
"

I am getting 2 blank space adove the '120120922XXXN' header line.I dont want 2 blank space at the strating of the file.And I want to return in footer '900000000' total record count.
EG:My output has 8 line excluding header footer.So i want to return like ''900000008'