Re: CPYFRMIMPF error 98

[Luis Rodriguez <luisro58@xxxxxxxxx>]

John,

In this particular case, if you can open it with Excel, could you upload it
to the iSeries using the Client Access Excel add-in?

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Thu, Oct 15, 2009 at 2:50 PM, jmmckee <jmmckee@xxxxxxxxxxxxxx> 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?
>
> John McKee
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.