List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:May 16 1999 2:15pm
Subject:Re: load data infile
View as plain text  
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
Thread
load data infileMike MacNeill16 May
  • Re: load data infileSasha Pachev16 May