Spool Data in a file

Shell Programming and Scripting
1

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

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):

D 11 120822FX400000046 208101981802950 33602205271 63080 G    01 20120713120718     466   01    01 FRAXX

The output I am getting is :

D                   11                  120822FX400000046   208101981802950 33602205271         63080               G                                                                               01                  20120713120718                                                                                466                                                         01                                                                              01
FRAXX

Kindly help..I don know why it is happening??

2

try using

COLUMN <<COLUMN_NAME>> FORMAT <<SIZE>>

if you know that column has say 2 character but defined as 10 char long then make size as A2.. in this way you can probably squeez in your data in one line..