AW: UDTF (or similar) to retrieve data from SYSPARTITIONSTAT

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Robert Clay
Gesendet: Tuesday, 24.9 2013 21:36
An: midrange-l@xxxxxxxxxxxx; midrange-l@xxxxxxxxxxxx
Betreff: Re: UDTF (or similar) to retrieve data from SYSPARTITIONSTAT



Tried that, both in STRSQL and iNav.  It doesn't recognize the "function"
because I created it as a procedure:

Message ID . . . . . . :   SQL0204       Severity . . . . . . . :   30
Message type . . . . . : Diagnostic

  Message . . . . :   LIBSTATS in QGPL type *N not found.
  Cause . . . . . :   LIBSTATS in QGPL type *N was not found. If the 
member name
    is *ALL, the table is not partitioned. If this is an ALTER TABLE
statement
    and the type is *N, a constraint or partition was not found. If this is
not
    an ALTER TABLE statement and the type is *N, a function, procedure,
trigger
    or sequence object was not found.
      If a function was not found, LIBSTATS is the service program that
contains
    the function.  The function will not be found unless the external name
and
    usage name match exactly.  Examine the job log for a message that gives
more
    details on which function name is being searched for and the name that
did
    not match.
  Recovery  . . . :   Change the name and try the request again. If the 
object
    is a node group, ensure that the DB2 Multisystem product is installed on
    your system and create a nodegroup with the CRTNODGRP CL command. If an
    external function was not found, be sure that the case of the EXTERNAL
NAME
    on the CREATE FUNCTION statement exactly matches the case of the name
    exported by the service program.


I guess I could re-write it as a function returning a table.

Thanks, anyway.

Robert

"Contrariwise, if it was so, it might be; and if it were so, it would be;
but as it isn't, it ain't. That's logic."--Tweedledee On 09/24/2013 3:15 PM,
Dan Kimmel wrote:
> SELECT MYLIB.* FROM TABLE(QGPL.LIBSTATS(' MyLib ')) AS MYLIB