Re: CSV files with Byte Over Marks

On 6/19/2018 1:21 PM, Soucy, Michael wrote:

I seem to be stuck between a rock and a hard place. I tried changing the attributes using the CHGATR command. When I do that it removed the BOM from the file,

I'm not sure I understand all the steps, but I'm imagining:
ADP > Export CSV > Stream file > IBM i Access file transfer > DB2 table

Scott K utility > ???

but now the program I wrote using Scott Klement's CSV parsing utility won't work. It's throwing a conversion error.

What specific utility, and what specific error? Can you post the bit of
code that's throwing the error? What's the CCSID of your job, your
QCCSID system value, the DB2 tables involved? If there's a 65535 in the
mix, that could be the issue, because 65535 means 'Do not translate this
binary data'. Except, of course, for IBM i Access, where there's a
checkbox to 'translate 65535' into... EBCDIC CCSID 37, I think.

I can't create the CSV file with CCSID 1208 because it's the result of a report I run from our payroll company (ADP). I contacted ADP before about it, and they stated that the file is being generated in the proper format and there is nothing for them to change.

Export the file from ADP to a new stream file.
WRKLNK that file and look at it in hex.
What's in there? Is it EBCDIC, ASCII (1252), UTF-8? Once you work out
the actual encoding, does the CCSID attribute match?
As a cross check, if you export from ADP to your PC, do you get the
exact same file, byte for byte?