RE: Those new SQL things on IBM i

I don't have it at hand, but I recall that Scott did an article on a UDTF that did just that - a list of stream files. It may have been a presentation for our user group a few years back.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, January 21, 2016 12:52 PM
To: Midrange Systems Technical Discussion
Subject: Re: Those new SQL things on IBM i

And you're going to play heck trying to find some IBM supplied SQL service to get a list of stream files.

May I suggest a DCR submitted through
https://www-912.ibm.com/r_dir/ReqDesChange.nsf/Request_for_Design_Change?OpenForm

If you're interested in rolling your own I could whip up a presentation on evolution which goes something like:
- Converting a subroutine into a subprocedure.
- Moving the subprocedure externally into a service program
- Creating a SQL UDF based on that subprocedure
- Embedding that UDF into a SQL view

Then if someone could take Scott Klements' API wrappers for stream files and figure out a way to put those into a view, or a UDTF, that would be really cool!


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
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.