Re: CPYFRMIMPF error 98

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

John,

Either;
On the CPYFRMIMPF you can specify the field delimiter.

Or:
Open in Excel, save it as an csv-file (delimiter the semicolon), copy to
IFS and use the command.

Could you also tell us  what reason code 98 is, Press F1 on the  message.

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 15-10-2009 at 14:20 jmmckee wrote:

> I have received a file from an outside agency that chokes CPYFRMIMPF. 
> The fields are pipe delimited.  I have looked at the raw file and don't
see anything REALLY obvious - the file is several hundred lines long.  I
> can open this thing in Excel just fine, but there is no option to save it
with pipe delimiters.  There is a free text portion, which, I suspect,
> prompted the need to use the pipe as a delimiter.  
>
> The agency has converted this file multiple times, and the results are the
same.  Other files are just fine.  When I attempted to use an error file,
> I got nothing in the created member.
>
> Is this why some of you loathe CPYFRMIMPF?  Any suggestions on how to
isolate and fix the error(s) causing CPYFRMIMPF to choke?  Not sure I have
> the time to write the program to split this thing apart.  Can SQL be used
in some way to identify or clean up the file?