Remove single quotes from db2 column name
As you found, you have to use '' to represent a single quote (').

You do not need to use the SPACE() function:

select replace(character_column, '''', '')
  from your_table


Note: Using SPACE() could actually create an issue as it returns VARCHAR(4000).