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;