Best way to load a CSV file on the host

[Nolan]

Sounds like you are converting the data too much to start with.  If this is a true CSV file created on a distributed system the line feeds should already exist.  The file should be sent to Z/OS as a binary file and then loaded with the generic indexer.  No conversion required.

OnDemand only puts out what you put in.  :)

[lfbeach]

This was the final step to make this work.  End of each line needs a hex'0D15' (and convert EBCDIC to ASCII)

   SORT FIELDS=COPY                         
   INREC BUILD=(1:1,78,X'0D15')             
   OUTREC OVERLAY=(1:1,80,TRAN=ETOA)       

Thanks for all assistance!

[Ed_Arnold]

Lori - thank you for closing the loop on this one and giving the final solution.

Ed