Re: SQL to read CSV file

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

That would work too, but I'm loathe to create temp work files.

Thanks

date: Fri, 18 Jun 2021 06:24:19 +0200
> from: "D*B" <dieter.bender@xxxxxxxxxxxx>
> subject: Re: SQL to read CSV file
>
> <Justin>
> I'm trying to get SQL to read a CSV file and output the parsed results. I
> can read the CSV with QSYS2.IFS_READ, but that only gives one column with
> the CSV all ran together. SYSTOOLS.SPLIT will parse a single CSV value,
> but I can't get it to take the IFS_READ as input.
>
> Am I just trying to accomplish too much in a single step?
>
> TIA
> </Justin>
>
> That's what CPYFRMIMPF is made for!
>
> D*B