Re: CPYFRMIMPF and extra columns

On 5/23/2013 5:03 PM, Matt Olson wrote:

It seems CPYFRMIMPF only works if the # of columns matches the number of commas in the CSV file you are trying to import.

Commas separate fields. If there's one comma, there are two fields. If
your CSV has 25 commas, you need 26 fields defined.

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.

The job log is somewhat helpful here. You can see which fields aren't
mapping and why. ish.

Is there an option in the CPYFRMIMPF I'm overlooking?

There are lots of options and they all need to match the data you're
trying to import. If none of the input rows converted, I'd guess that
the end of record character is the culprit. If your file is coming from
*nix, EOR is *LF. If coming from Windows, EOR is *CRLF. I've had poor
luck with the default *EOR.

You need to exactly match the string delimiter (usually a double quote
but sometimes nothing at all!) and the field delimiter (usually a comma
but sometimes a tab). If it's a big file and it takes a long time to
process, try FROMRCD(*FIRST 10) or some small number that will get your
parameters tested quickly. Don't forget about RPLNULLVAL - you may need it.
--buck