Re: Flat file creation problems

From: DI Karl Heinz Hörmann <kh.hoermann_at_penta.at>
Date: Tue, 25 Jan 2000 02:51:08 +0100
Message-ID: <86iv8i$p04$1@newsmaster01.magnet.at>

Ste C. schrieb in Nachricht <8678so$5g5$1_at_nnrp1.deja.com>...
> I want to create a flat file from a table

>select column1 a,
> column2 b,
> column3 c,
> column4 z
>from columns
>where column3 = 'Y'

>when I edit the file temp.lis the output looks like
>
> 11111AAAAAAAAAAAAAAAAAAAAAAAAAY 1111
> 22222AAAAAAAAAAAAAAAAAAAAAAAAAY 2222
> 33333AAAAAAAAAAAAAAAAAAAAAAAAAY 3333
> 44444AAAAAAAAAAAAAAAAAAAAAAAAAY 4444
> 55555AAAAAAAAAAAAAAAAAAAAAAAAAY 5555
this problem led me to use explicit formatting and concatenation like

select lpad(to_char(a), 5, 0) ||

         rpad(b, 25) ||
         ...

in the past ... Received on Mon Jan 24 2000 - 19:51:08 CST