In V5R3, IBM simplified the manipulation of character strings with the implementation of the INSERT and REPLACE functions in SQL. INSERT allows the positional insertion of one or more characters in a string and REPLACE scans for all occurrences of a target string and overlays or replaces the target string with a replace string. INSERT was discussed in my previous article, and now I will discuss REPLACE.

Prior to the implementation of REPLACE in V5R3, scanning for the existence of a target string and replacing it with another string was not very easy. A positional replacement could be performed

I’m having a problem downloading a file using iSeries Access Data Transfer from System i. Whenever I perform my download, I get the CWBDB0099 and SQL0420 errors shown below. I can click OK and still download the file, but I’d like to get rid of this error. What’s going on and how do I fix it?

–Laura

Here’s the error message that Laura is referring to and what I did to solve it.

After researching, I couldn’t find any references to the CWBDB0099 error with the SQL4020 sub-error. There were plenty of references to the CWBDB0099 error with sub-error SQL0181,

After a damaged object prevented a full system production backup in my shop, I was asked to devise a technique for detecting damaged objects on the system. This week, I’m presenting my starter CL program that looks for damaged objects as a template for approaching the issue, in the hopes that others can add to and expand on this code.

How Objects Get Damaged

iSeries, System i, and Power i objects can get damaged in a variety of ways, including:

• Electrical outages where the power is quickly cut off before the hard drive has a chance to finish writing all