Re: Those new SQL things on IBM i

IBM is doing a lot of documentation on developerWorks as of late, and these
DB2 for i Services are no exception: http://bit.ly/db2-for-i-services

The IBM i Dash project is making use of a few of them:
http://bit.ly/litmis-ibmidash (Node.js)
Jon Paris and Susan Gantner just wrote an article about it:
http://bit.ly/db2-for-i-rpg (RPG)

Aaron Bartell
litmis.com - Services for open source on IBM i


On Thu, Jan 21, 2016 at 2:09 PM, Jeff Crosby <jlcrosby@xxxxxxxxxxxxxxxx>
wrote:

Brain fart day.

The last few months have seen various discussions on new SQL capabilities.
Things like getting a list of active jobs or PTF group level and whatnot.

1) What are those capabilities called? Functions?

2) Is it 7.2 only? Or 7.1 also?

3) Where can I find documentation on what's available?

I have a project coming up in a month or so where I will want a list of
files in an IFS folder. I'm hoping I can get that file list this way.

Thanks.


--


Jeff Crosby
VP Information Systems
UniPro FoodService/Dilgard
P.O. Box 13369
Ft. Wayne, IN 46868-3369
260-422-7531
www.dilgardfoods.com

The opinions expressed are my own and not necessarily the opinion of my
company. Unless I say so.
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.