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

... 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'
;