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

[Booth Martin <booth@xxxxxxxxxxxx>]

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