Spooling data to CSV truncates
- by Steve
Hi,
I am using the below script to output data to a csv file:
set heading off
set linesize 10000
set pagesize 0
set echo off
set verify off
spool D:\OVERNIGHT\TEMP_FILES\PFRA_DETAIL_VIXEN_OUTPUT.txt
SELECT
TRIM(T4.S_ORG_ID)||','||
TRIM(T4.NAME)||','||
TRIM(T3.CREATION_TIME)||','||
TRIM(T5.X_HOUSE_NUMBER)||','||
TRIM(T5.X_FLAT_NUMBER)||','||…