Removing Blank lines between data rows in CLPPlus

353 Views Asked by At

Hi I have google this many many times but i cannot seem to find the resolution. The resolutions suggested previoulsy do not seem to work for me. I am using CLPPlus to query DB2 and when i create the spool file i get a blank row after each data row. I have set pagesize to 0, changed the trim settings so no leading whitespace. None of these worked. Please see the screenshot below for further help Please see the code below:

set echo off
set colsep '|'
set pages 0
set trimspool on
set headsep "|"
set linesize 500
set heading on
set feedback off
set timing off
set recsep off

spool C:\Users\mkhan59\Desktop\CLPPlus\DB2_Result.txt

set termout off
Select Query Here;
set termout on
SPOOL OFF

As you can see from Screenshot there are blank lines after each row.

0

There are 0 best solutions below