Re: SQL to read CSV file

I used ACS' run sql scripts and <edit><Insert Generated SQL>

navigate to systools then functions and select SPLIT.

as Vern said you may be able to insert some code to handle the double quote.

Bryan

John Yeung wrote on 6/18/2021 2:35 PM:

On Fri, Jun 18, 2021 at 2:19 PM Bryan Dietz <bdietz400@xxxxxxxxx> wrote:

- maybe you could scan/replace the "unneeded" characters.

I don't think that would help; otherwise SYSTOOLS.SPLIT() would
already be sufficient.

- "retrieve the SQL source" for split, modify and recreate as your own.

Not quite sure what you are trying to say there, but it sounds
suspiciously close to rolling your own CSV parser.

- non sql option https://www.scottklement.com/csv/

This is a good idea. Odds are that Scott's CSV parser is at least as
good as anything you would roll on your own, and it's already rolled!

If your SQL host language is RPG anyway (i.e. you were trying to write
an SQLRPGLE program), then why not use Scott's?

John Y.