We have a need to FTP a .csv file onto the mainframe, then we're going to load this directly to DB2. Only thing is, I want to replace some generic data (part of the audit fields) with a system generated value.
Now this would be easy enough with a 'normal' dataset, but because we need to use a .csv file, the data we need to replace will be at various different offsets. What i'm hoping to achieve is to replace 'RESUME' with 'AAnnnnnn' and the file could look something like this:
Was wondering if I could use an OVERLAY, but not sure if this can be done without providing a fixed offset. Is this something which can be done in SORT or ICETOOL?