IBM Mainframe Forum

hi,
Is it correct one to replace a full column with space in a flat file.

what happened when You tried ?
but why use FINDREP when a simple BUILD or OVERLAY would be probably perform better ?

see here for

DFSORT Smart tricks
http://www.ibm.com/support/docview.wss? ... g3T7000094

or read about sort advanced functionalities starting from
http://www.ibm.com/support/docview.wss? ... g3T7000079

also remember that out of context question will usually lead to incomplete answers

If you want to replace position 5 for a length of 4 with space for each record on your file:

daemian,

The syntax you used for FINDREP is not correct. This would be a better choice for what you want to do:



If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080

thank you so much frank and billy..

Hi,

Please find below an example on how to use FINDREP -



Please note that this example is just for your refernce & will not solve the purpose.

Please note that INOUT works in pairs & hence, William will be replaced by Bill, Mike by Michael & so on.

Also be aware that in the example shown, searching will start at the beginning of the record and end when the search can no longer be fulfilled (ie nearly the end of the record). If there are multiple occurences of the IN values, there will be multiple changes.

These effects can be modified by STARTPOS, ENDPOS and DO. There are also options to control the effects of the replacement (if potentially causing the output record to be longer).