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

I can not make it compile with the "where" clause.

exec SQL select ODOBTX into :wUserName
from Table(QSYS2/USERS() )
where ODOBNM = 'MARTIN'
MSG ID SEV RECORD TEXT
SQL0104 30 143 Position 38 Token ODOBNM was not valid. Valid tokens:
FOR WITH FETCH ORDER UNION EXCEPT OPTIMIZE.




On 10/8/2015 6:15 AM, Birgitta Hauser wrote:

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;

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!"