formatting columns for flat file export

Can anyone give me a hand?

I need to export some tables to fixed-width ASCII for import into another database. The problem is that one of the tables contains some long fields, 400 and 200 characters. I was testing it with the following:

SET ECHO OFF
SET FEEDBACK OFF
SET SPACE 1
SET LINESIZE 415
SET PAGESIZE 60 COL docno heading '' format a15
COL title heading '' format a400
SPOOL /cases/test.dat
select docno, title
from prv_main
where docno like 'MEP098%'
/
spool off
set lines 80
set pages 85
set feed on
set echo on

The problem is that the title keeps wrapping, no matter what I set the page width to. Any help??

Thanks,

Tom Mettling
mettling_at_erols.com Received on Mon Aug 12 1996 - 00:00:00 CEST