Spool Data in a file

view story

http://www.unix.com – Hello, I am trying to spool data from database into a file on solaris through ksh. Data is getting fetched but the problem is record is getting split in to multiple lines. excerpt from sql is Code: whenever sqlerror exit 1; set define on set echo off set feed off set head off set trimspool on set verify off set linesize 150 set newpage 0 set pagesize 0 set space 0   select * from &2;   SPOOL OFF; quit; Table data is (below each field separated by space): Code: D 11 120822FX400000046 208101981802950 33602205271 63080 G    01 20120713120718  &nbs (HowTos)