The Sql TRANSLATE() function replaces a sequence of characters in a string with another sequence of characters. The function replaces a single character at a time.
Example:
Select TRANSLATE(‘This@is@an@example.’, ‘ ‘, ‘@’ )
From Sysibm/Sysdummy1
Result: This is an example.