Re: CPYFRMIMPF and extra columns

[Alan Campin <alan0307d@xxxxxxxxx>]

Yea, don't use CPYFRMIMPF. Nothing but trouble. Read the file directly from
the IFS and write the database records. I have API's for reading IFS and
tokenizing the records if you are interested.


On Thu, May 23, 2013 at 3:03 PM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

> Folks,
>
> It seems CPYFRMIMPF only works if the # of columns matches the number of
> commas in the CSV file you are trying to import.
>
> I tried adding extra column at the very end of the destination file that I
> want to take the CSV file into, but then it doesn't parse any records.
>
> Is there an option in the CPYFRMIMPF I'm overlooking?
>
> Thanks,
>
> Matt
> --
> 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.