Re: generating flat files with no blank caracters

Thanks,

but i've an another question, no it's the same question : i generate a flat file like this
" 1058| 2| 2| 74|20-OCT-01|V| 6|" doing a select * and i want to know if i can eliminate the blank caracters only modifying the setting of sqlplus. My question it's perhap's idiot but using Informix i do a "unload to <filename> select * from <tabname>" it' possible to do so easily the same thing.

Raphaël

Roel Toledo a écrit :

> > I want to generate a flat file so i can use it for partial loads on over
> >
> > databases, but when i do it with sqlplus, number's columns are completed
> >
> > with blank caracters and the file can't be use with sqloader. So how i
> > should do to get a no blank car file.
>
> Issue your query like this:
>
> SELECT TRIM(column1)||TRIM(column2)||TRIM(column3)
> FROM table_name;
>
> The TRIM function works on most datatypes including numbers.
Received on Wed Oct 24 2001 - 09:12:09 CEST