unix script errors

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

#!/bin/ksh

sqlplus -s user/passwd@remoteserver << EOF > errors2.log

set pagesize 0 feedback off verify off heading off echo off

select directory_nm || '/' || file_nm || '|' ||venue_id || '|' || time_id from file_control;
EOF

The output of this script is;

/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|
28991|1130198400

/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|
25881|1130198400

/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.20050711210100|
25881|1130198400

/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.20050711210100|
28991|1130198400

The desired output is: the directory_nm, filename,venueid and timeid must be in the same line.

/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|28991|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050713211544.20051025.20050713211544|25881|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.20050711210100|25881|1130198400
/mnt/datagridx/MKG/perm/testdata/DSA.WLG.20050711210100.20051025.2005071121010028991|1130198400

Can you tell me why the output from the korn script is printing in 2 lines instead of single line. I tried to debug it could not.

can anyone hep me please.

Thanks

2 
sqlplus -s user/passwd@remoteserver << EOF > errors2.log
set pagesize 0 feedback off linesize 240 verify off heading off echo off
select directory_nm || '/' || file_nm || '|' ||venue_id || '|' || time_id from file_control;
EOF

Add linesize setting

3

Thanks A Lot Buddy

Good Weekend