Mit freundlichen Grüßen / Best regards
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
"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!"
[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
is *ALL, the table is not partitioned. If this is an ALTER TABLE
and the type is *N, a constraint or partition was not found. If this is
an ALTER TABLE statement and the type is *N, a function, procedure,
or sequence object was not found.
If a function was not found, LIBSTATS is the service program that
the function. The function will not be found unless the external name
usage name match exactly. Examine the job log for a message that gives
details on which function name is being searched for and the name that
Recovery . . . : Change the name and try the request again. If the
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
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.
"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