Re: CPYFRMIMPF error 98

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?