SQL Plus Spool - I can't get rid of a trailing blank line in the output file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL Plus Spool - I can't get rid of a trailing blank line in the output file

Threaded View

  1. #1
    Join Date
    Feb 2014
    Posts
    3

    SQL Plus Spool - I can't get rid of a trailing blank line in the output file

    Hi, I need to create a text file that is fixed format of 131 characters. I am not able to find a way to remove the 1 trailing blank line at the end of the output file. This is what I have now. I have tried several other set commands in various combinations, but still get the trailing blank line.

    set heading off
    set feedback off
    set verify off
    set trimspool off
    set term off
    set colsep ''
    set space 0
    set pagesize 0
    set linesize 131
    spool D:\egis\MapidUpdate\C2MapidUpdate.txt

    select LPAD(' ',24) as FILLER1, RPAD(LK.MAP_PAGE,4) as MAPIDFROMSERVICE, LPAD(' ',35) as FILLER2,
    LPAD(C.SIT_ID,9,'0') as SITEID, LPAD(C.IS_SEQ_NUM,9,'0') as INSTSERV, LPAD(' ',50) as FILLER3
    from GIS_C_lOCATION@ORAC2Rdv.world C
    join ELECTRIC.SERVICE_TB S on C.SIT_ID_ISS_SEQ_NUM = S.CUSTOMER_ACCOUNT_NO
    join electric.electric_service_point_tb e on s.electric_service_point_id = e.id
    join ops$enom.SERVICE_POINT_MAP_PAGE lk on lk.elec_service_point_id = s.electric_service_point_id,
    electric_land.state_tb st
    where SDO_RELATE(e.location , st.extent, 'mask=anyinteract querytype=WINDOW' ) = 'TRUE'
    and trim(LK.MAP_PAGE) != trim(c.psnh_map_num)
    spool off;
    /
    quit;


    The output file is attached.

    Any help would be greatfully appreciated.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width