On 19-Nov-2015 10:53 -0600, rob wrote:
All nice teases but I suspect Paul is working on some ancient system
that "if it isn't broke, why fix it?" and he will be relegated to
And why not use Retrieve User Profile [or Retrieve Object Description
(RTVOBJD)] irrespective of the modernity of the system\version? The
request from the OP, almost surely is not best served by any of the
previously mentioned UDTFs or any VIEW implemented on such a UDTF.?
Just how and why, on a system with perhaps up to many thousands of
users, a request that would gather the information about *all users*,
could satisfactorily be considered a /fast/ means to obtain just one
datum of just one specific user; processing that would seem to mimic
quite closely [even if the UDTF is faster than] the behavior of the
Display User Profile (DSPUSRPRF) for the information of TYPE(*BASIC)
that the OP seemed intent on avoiding?
I just do not understand the seemingly overwhelming amorousness being
so fervently and so often expressed towards the various DB2 /services/
features that perform vastly more work than necessary; what would then
get pared down to just one row by selection implying that the data would
be reprocessed [i.e. scanned after generated] and would effect the
overwhelming amount of data remaining /purposefully unreferenced/ as
actual output to the program.
By all means use those services for the convenience and with purpose,
but please do also exert _some effort_ in contemplation of the actual
amount of work they entail, before thoughtlessly deferring to those
services. From the OP, there seems little justification, in fact quite
the opposite, in using those services over using the much simpler
RTVUSRPRF [or RTVOBJD].
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2021 by midrange.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 on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.