RE: Transfer a text file from the IFS

["Terry Anderson" <terrya@xxxxxxxxxxxx>]

Chris,
You said:
> > CPYFRMIMPF will put IFS stream files into a database file however it
only 
> > supports standard text file delimiters such as tab or comma with
quotes around the text.
 
I have dozens of files that I import straight into the database on the
i5 with CPYFRMIMPF that use other delimiters, mostly the pipe(|) symbol,
with no quotes around the text.

Did I misunderstand your statement?    


Terry Anderson
Programming Manager
Citation Corporation
Switchboard 1.251.867.5481 ext 212
Direct Line 1.251.809.2312
Fax 251.867.0525
Cell  1.251.363.4975

> > ------------------------------
> >
> > message: 10
> > date: Mon, 25 Feb 2008 09:21:02 -0800
> > from: "Chris Bipes" <chris.bipes@xxxxxxxxxxxxxxx>
> > subject: RE: Transfer a text file from the IFS 
> >
> > What format is the data in the text file?  CPYFRMIMPF will 
> > put IFS stream files into a database file however it only 
> > supports standard text file delimiters such as tab or comma 
> > with quotes around the text. I usually create an import 
> > library and special import files that are the same layout as 
> > the text files.  I can then copy to the real database 
> > mapping the fields over to the production file.  I like to 
> > use RPG to validate the data as well.
> >
> >
> > Chris Bipes
> > Director of I.S.
> > CrossCheck, Inc.