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

[Booth Martin <booth@xxxxxxxxxxxx>]

Bingo, Chuck.  You nailed it.   Thank you.



On 10/8/2015 5:15 PM, CRPence wrote:
>  ...  The given example could have been clearer, having qualified the
> column name(s), and including the optional AS keyword to make the X
> appear less like a spurious data from a mis-type\finger-check.
>
>    Try the following revision to what you have quoted above; I used CID
> instead of X, hoping to make clear, that the text is intentionally
> included, and the identifier as qualifier on the column-name references
> helps elucidate the purpose of the AS-identifier:
>
>       exec SQL
>         select CID.ODOBTX
>         into :wUserName
>         from Table( QSYS2/USERS() ) AS CID
>         where CID.ODOBNM = 'MARTIN'
>       ;