zOs/SQL/ABUBRULE

update   oa1p.tqz046AbubRule
  set va4 = trim(left(va4, 65))
    where rule like 'logE2%'
      and  type = 'code'
;
select length(va4), hex(va4)
      , trim(left(va4, 65))
      , r.*
    from oa1p.tqz046AbubRule r
    where rule like 'logE2%'
      and  type = 'code'
;
commit
;