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.