To copy only last

Anand78 · New User Joined: 06 Mar 2006 Posts: 48 Location: PUNE

I have one extract file. It's holding work of date in the last record and some information. I need to copy only the last record into some other file for further process.

Please advise me how to achieve this task using DFSORT.

krisprems · Posted: Fri Jul 04, 2008 6:15 pm Post subject:

check this example

Frank Yaeger · Posted: Fri Jul 04, 2008 8:47 pm Post subject:

Krisprems,

Your solution assumes that the OP's input file has RECFM=FB and LRECL=80. That may or may not be the case, but you should have mentioned it.

Anand78,

If you need more help with this, show an example of your input records. Is there anything unique about the "last" record that can be used to identify it? What is the RECFM and LRECL of your input file?

Anand78 · New User Joined: 06 Mar 2006 Posts: 48 Location: PUNE

Hi ,

The last record is having only date,time and count.
LRECL = 80
RECFM = FB

I copy paste the last record

...................................07/01/2008 200000 14:30

Thanks
Anand

Frank Yaeger · Posted: Mon Jul 07, 2008 9:03 pm Post subject:

Anand,

Since your input file does have RECFM=FB and LRECL=80, you can use the DFSORT job Krisprems showed (I'm surprised you didn't just try it).

Frank Yaeger · Posted: Wed Jul 30, 2008 1:50 am Post subject:

You can do this kind of thing quite easily without worrying about the RECFM or LRECL using the new SUBSET operator of DFSORT's ICETOOL available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008):