Re: User profile Personal Info

Glenn,
I did not see them in there.
I believe that he's looking for stuff in WRKDIRE, not in WRKUSRPRF.
Honestly we no longer enter information in WRKDIRE.
This might be the stuff in qusrsys/qaokp09a. Well, I think department is
in there at least.

On Mon, Mar 4, 2024 at 2:42 PM Glenn Gundermann <glenn.gundermann@xxxxxxxxx>
wrote:

Hi Justin,

Take a look at these two statement to see if they give you what you need:

SELECT *
FROM USER_INFO;

SELECT *
FROM USER_INFO_BASIC;

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144



On Mon, 4 Mar 2024 at 12:59, Justin Taylor <jtaylor.0ab@xxxxxxxxx> wrote:

Is there a SQL service that will return personal info from a user profile
(e.g. SMTP name, department)?

TIA
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.