I have an input file containing 5 fields (columns).
I want to keep only last column and remove the rest in my output.
Also last field contains numeric values. I want to add them and write in the output file.
Can anyone help me out?
You can use any JCL/control card. I will modify that accordingly.
What is the starting position, length and format of the last column? The format indicates which type of numeric value it is (e.g. ZD, PD, BI, FI, etc).
Please show an example of your input records (relevant fields only) and what you expect for output (e.g. do you want the records and the total, or just the total, what do you want the total to look like, etc).
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: