Re: load data infile

[Sasha Pachev]

Mike MacNeill wrote:
> 
> I am loading a data file from my AS400 and
> the file contains some extra fields that I don't
> want to load:
> 
> load data infile 'caf131.txt' replace
> into table data.inventory
> (       serialnum, status, subnum,
>         icode2, icode,
>                ,         <--- unwanted column in data file
>         worknum,
>                ,         <--- unwanted column in data file
>                ,         <--- unwanted column in data file
>         installdate );
> 
> How do I designate the columns I don't wish to load. Is it currently
> possible?
> 
> mikem@stripped

Write a Perl script to clean out the data.

-- 
Sasha Pachev
http://www.sashanet.com