Here is some simple code that we use to do a mass replace of text strings in physical file source members. It does a case sensitive search and replaces the entire search string with the replacement sting and will always produce data shift if the search and replacement...
We needed to do a table update remotely over the internet from a very old version of OS/400 (V4R3) using SQL in an RPGLE program on a table which was on a remote machine running a much newer version (V7R1). The connection of the two machines is across the internet....