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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.