On 8/5/2014 10:33 AM, CRPence wrote:
On 05-Aug-2014 08:36 -0500, Gqcy wrote:There is a UDTF for a single library, provided by IBM - you can use
Does someone have a SQL that I can run that will show theA procedure [or ILE or OPM program] that gathers the result from
requesting Size via the Retrieve Library Description (QLIRLIBD) API
can be encapsulated in a scalar User Defined Function (UDF). The
routine would be defined to the SQL via CREATE FUNCTION [external
*ALL for the object types - here is an example of its use:
SELECT * FROM TABLE (QSYS2/OBJECT_STATISTICS('VHTEST ','*ALL')) as x
It can do only one library. Oh, yeah, I said that already - heh!
Brief docs for this and other services are at -
On that page, click at "attachments" near the bottom for a link to a
Powerpoint showing the various services, both DB2 and system -
Very cool stuff being provided by the database team at IBM.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact