Where do the japanese characters come from ? a file, a screen, ....
Do you have a unicode DB2 table ?
how hard can it be :
set column Col1 to æ—¥æœ¬
01 Y pic N(10) usage national.
. . .
Move NX"65E5 672C" to Y
exec sql update table1 set Col1 = :Y where ...
I can explain it to you, but i can not understand it for you.