MVSFORUMS.com

[vkphani]

Hi !!

I want to update the 3rd byte of a character field in a table with character

[Phantom]

vkphani,

Check this link.
http://www.mvsforums.com/helpboards/viewtopic.php?t=2938&highlight=character+function

Hope it solves your problem,

PS: I am not good in DB2 but I think there is a better solution. Let me see if I can find that for you.

Thanks,
Phantom

[vkphani]

Yes Phantom,

I too searched for this in the forum. But didn't get any results.
Anyway thanks for the help.

[Phantom]

vkphani,

I have seen a similar question - long time back. Kolusu had given a solution using column/char functions.

Try if you could do something using the REPLACE function.
http://www.mvsforums.com/helpboards/viewtopic.php?t=4453&highlight=replace

Thanks,
Phantom

[kolusu]

vkphani,

Try this untested sql

[Phantom]

Kolusu,

I thought (very vaguely remember) I saw some string function to replace a particular position(s) of the string - directly. And you were the one who gave that solution. I don't know where and when I saw that. Isn't there any other way to accomplish this.

Thanks,
Phantom

[kolusu]

Phantom,

Replace Function works for the entire column and if the string is known. However in this case the 3rd byte is unknown.

I guess you are referring to the solution posted in here

http://www.mvsforums.com/helpboards/viewtopic.php?p=15976#15976

[vkphani]

Thanks for the help Kolusu.

Kolusu,

Is there any specific reason behind mentioning so many CONCAT statements in the query.

Even the below query works.

[kolusu]

[vkphani]

Thanks for the help Kolusu.

[Rahull]

How will i do the same(Update any byte) if my column data type is S9(13) COMP-3.

[kolusu]

Rahull,

If the update column is decimal column , then you need to expand it and then update it.

ex: assume the following data