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