Re: Read IFS file using SQL

Thanks Luis.
This information is very helpful.

Jeff Young
Sr. Programmer Analyst

On Fri, Jun 30, 2017 at 10:05 AM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

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

--

Luis Rodriguez
--
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