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

[Robert Clay <zreclay@xxxxxxxxx>]

Thanks, Birgitta

I'll add the SET statement.

As stated in the original post, this is for a version 6.1.0 LPAR but 
thanks for the 7.1 view concept.  I'll keep it in mind if I ever get to 
work on a 7.1 system. :)

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/28/2013 4:13 AM, Birgitta Hauser wrote:
> You may get a better performance avoiding the UPPER(TRIM(ParameterValue)) in
> the RETURN SELECT statement.
> Just add a  SET Statement before the return statement and use the (modified)
> SCHEMA_NAME in your SELECT statement:
>
> BEGIN
>     Set Schema_Name = UPPER(TRIM(Schema_Name);
>     Return SELECT ...
>             WHERE  Sys_DName = Schema_Name
> ...
>
> If you are on Release 7.1 creating a VIEW (instead of an UDTF would be the
> better option).
> The schema_Name can be included as Global Variable (CREATE VARIABLE) and set
> in your environment immediately before using the view.
>
> Birgitta
>
> 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!"