Instead of "USER" wouldn't you be searching on DEF? For example,
select LookupTheName(USER) from ...
where LookupTheName(USER)= 'Doe, John Q.'
CREATE VIEW FOO/BAR_V1 (RECORD_ID, CATEGORY, TYPE, USER,
CREATED_USER, ACCOUNT_ID, ACTIVITY_ID, NOTE_FLAG, DOC_FLAG ) AS SELECT ACCRID, DISPLAYVAL(9001, DIGITS(ACCCAT)),
DISPLAYVAL(9011, ACCTYP), DISPLAYVAL(9012, DIGITS(ACCUSR)),
DISPLAYVAL(9012, DIGITS(ACCCUS)), ACCEID, ACCAID, ACCNOT, ACCDOC FROM FOO/BAR ; LABEL ON COLUMN FOO/BAR_V1 ( CATEGORY IS 'Category', TYPE is 'Type', USER IS 'User', CREATED_USER IS 'Created User'
select DEF INTO result from FOO/LOOKUP where PTBLE = substring(tbl from 1 for 3) and PCODE = substring(i_key from 1 for 5) and STBLE = ' ' and SCODE = ' ';. . .