update rwlex305/rwliefp
set lifuid =
(select substr(attax, 1, 15) from dcwd/ataxno
where rwliefp.lilikrkto = atanum
and attax <> ' ' and atagr = '305')
where lifuid = ' '
and exists (select * from dcwd/ataxno
where rwliefp.lilikrkto = atanum
and attax <> ' ' and atagr = '305')
Bookmarks