0

I am using Datastage 11.5

Conside the input string 'This is � Test'.

I want to avoid such data to be inserted or get the value replaced with ''

Db2Cramp
  • 33
  • 7

1 Answers1

0

Check out the convert function. You can list a number of characters and a replacement character or string. The only problem is to identify all characters you want to get rid of.

MichaelTiefenbacher
  • 3,805
  • 2
  • 11
  • 17