Re: SQL Select From IFS file

Just to reinforce another post - yes, with the DB2 Text Extenders you can do 
this. It is an extra-cost feature.

The extenders give you some user-defined functions that work against a stream 
file in IFS. These can be inserted directly into a SELECT statement, which can 
be run in iSeries Navigator.

HTH
Vern
-------------- Original message -------------- 

> I want to do a Select * from /MYIFSFOLDER/MYIFSFILE on a text file 
> sitting in my IFS from the Run SQL Scripts window in iSeries Navigator. 
> Is there a way to do this? 
> 
> David Smith 
> IT Consultant 
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list 
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx 
> To subscribe, unsubscribe, or change list options, 
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l 
> or email: MIDRANGE-L-request@xxxxxxxxxxxx 
> Before posting, please take a moment to review the archives 
> at http://archive.midrange.com/midrange-l. 
>