I have a flat file in that i need to replace one entire column with sapce, can anyone tell me how to do that?
If you want help when you ask a question, you need to give the details of what you want to do. Otherwise, we can only guess.
However, as an example, if you wanted to replace positions 11-14 in each input record with spaces, you could use a DFSORT job like the following:
//S1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
You can change 11: and 4X to meet your needs. For example, if you just want to change position 21 to a blank, you would use 21:1X instead of 11:4X.
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