Hi, all
I am trying to remove certain garbage characters from a field in DB2 LUW 9.5 on AIX. I have found that I can replace everything up to and including ascii 193. Once ascii 194 or above appears, translate fails with SQL0176. I can display characters > X'C1' but not translate them out of a string. Any ideas?

adal935% db2 "values translate(X'31C133','~',X'C1',' ')"

1
---
1~3

1 record(s) selected.

adal935% db2 "values translate(X'31C233','~',X'C2',' ')"

1
---
SQL0176N The second, third or fourth argument of the TRANSLATE scalar
function is incorrect. SQLSTATE=42815
adal935% db2 "values X'31C233'"

1
---
13

1 record(s) selected.