Re: formatting columns for flat file export

Tom Mettling wrote:
>
> 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

If your goal is to not display column headers just use the SET HEADING OFF command in your original 'set' commands. Received on Tue Aug 13 1996 - 00:00:00 CEST