Re: Read IFS file using SQL

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Jeff,

Some years ago Birgitta Hauser wrote a DeveloperWork's article about UDTFs,
and one of the examples was using an UDTF for reading .CSV files. I *think*
those may be the references you mention.

Birgitta's article can be found here:

https://www.ibm.com/developerworks/ibmi/library/i-power-of-udtf/

HTH,

Luis

On Fri, Jun 30, 2017 at 9:33 AM Jeff Young <jyoung0950@xxxxxxxxx> wrote:

> All,
> I have seen references here recently and in the past regarding using SQL to
> read /Write files (tables)  residing on the IFS, but can not find anything
> in the IBM reference manuals.
> I am working with systems on 7.2.
>
> Can someone point me to the appropriate manual or link on how to do this?
>
> I am very comfortable working with SQL and even the Unix/C procedures for
> accessing the IFS in RPGLE.
>
>
> Jeff Young
> Sr. Programmer Analyst
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD