Want to keep only last column and remove the rest

sharad_shanu · New User Joined: 03 Oct 2006 Posts: 40

Hi,

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.

-Sharad Srivastava

Frank Yaeger · Posted: Thu Jan 24, 2008 10:06 pm

You need to provide more information.

What is the RECFM and LRECL of the input file?

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:

Use [URL] BBCode for External Links