Re: AW: Retrieve a user's full name (not the User ID)

I was amazed by this function, but confused because I hadn't seen it
before. I went looking for it in a reference chart I have from IBM online,
and I didn't find this table function, but I did find the QSYS2.USER_INFO
view. This view seems more restrictive by my authority to this data,
possibly because there are a lot of fields in there. This QSYS2.USER()
table function returns more results, possibly because the name of the user
isn't subject to tight profile controls. I find that interesting.

IBM Provided an UDTF (User Defined Function) named USERS(), located

within

the QSYS2 library.
You easily can access this UDTF with (embedded) SQL:

Exec SQL Select ODOBTX into :HostVariable
from Table(Qsys2.Users()) x
Where ODOBNM = :HostUsrPrf;