Remove blank line from Spool file

2.1k views Asked by At

I am creating a .tab file using Spool simply by doing a select statement.

The select statement returns Y

However when running the below script the output files has a blank line after the Y.

Can you please assist me in removing the line as I have tried looking all over.

Set Heading Off;
SET NEWPAGE NONE;
SET LINESIZE 1;
SET PAGESIZE 0;
SET TRIMSPOOL ON;
SET SQLBLANKLINES OFF;
SET FEEDBACK off;
SET WRAP on;
SPOOL \\Planning\Lists\Admin\elapse.tab;
Select txt1 from ack_work_text_1;
Spool Off;
0

There are 0 answers