SET pages 0
SET linesize 10000
SET TRIMSPOOL ON
SET term OFF
SET verify OFF
SET feedback OFF
SET COLSEP "|"
SET LONG 32000

SPOOL D:data_transfercrmpartnerscsvfilesBrazilSiteCoreSOL_REPORT_%SD%.csv

SELECT '"'||"SR_NUM"||'"|"'||"FST_NAME"||'"|"'||"LAST_NAME"||'"|"'||"NAME"||'"|"'||"ALIAS_NAME"||'"|"'||"ATTRIB_02"||'"|"'||"LOC"||'"|"'||"CUST_STAT_CD"||'"|"'||"INTEGRATION_ID"||'"|"'||"ACT_CLOSE_DT"||'"|"'||"ACT_OPEN_DT"||'"|"'||"WRNTY_LAST_UPD_DT"||'"|"'||"NOTE"||'"' FROM SOLICITATION_REPORT_PARTNERS;

spool off