find and replace linefeed character in DB2 Database

replaceLineFeedCharacter.sql

-- find all Line Feed Characters \u000A, chr(10), chr(13)
select * from verkauf.faserbc 
where fbaun1=5620 
and 
( instr(FBTEXT, chr(10)) > 0
      or
      instr(FBTEXT, chr(13)) > 0
    )    
;  
 
-- and replace
update verkauf.faserbc SET 
FBTEXT = replace(FBTEXT, chr(10),' ') 
where fbaun1=5620 
and 
( instr(FBTEXT, chr(10)) > 0
      or
      instr(FBTEXT, chr(13)) > 0
    )    
;