How to sort the records leaving the first and the last

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Hi ,

I need to sort a Sequential file of RECFM=FB and LRECL=80
Here i should not sort the first and the last records.So the records between the first and Last records should be sorted.

Sort Fileds=(1,4,ch,a)

Input

AAAAA
CCCCC
BBBBB
XXXXX
DDDDD
ZZZZZ

Output
AAAAA
BBBBB
CCCCC
DDDDD
XXXXX
ZZZZZZZ

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Typo Mistake : ZZZZZZZ
It should be ZZZZZ

Aaru · Posted: Wed Aug 06, 2008 3:51 pm

Sri,

Did you check the new DATASORT operator introduced in DFSORT? I think this can be done easily using the new operator?

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Thanks Aaru for your suggestion But i do not have PTF installed.

Frank Rpely in that Link: Note that you will need z/OS DFSORT V1R5 PTF UK90013 (July, 2008) in order to use the new DATASORT operator

expat · Posted: Wed Aug 06, 2008 4:08 pm

Have you searched the forum, as I do recall a request to do EXACTLY what you want to do.

I think HEADER and TRALER were in the title of the thread, or the text body, so should not be too difficult to find.

Aaru · Posted: Wed Aug 06, 2008 4:23 pm

Sri,

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Aaru · Posted: Wed Aug 06, 2008 5:11 pm

You are welcome and good that it is working.

Frank Yaeger · Posted: Wed Aug 06, 2008 10:41 pm

If you have z/OS DFSORT V1R5 PTF UK90013 (July, 2008), you can use the new DATASORT operater to do this kind of thing. See:

Use [URL] BBCode for External Links

If you can't use DATASORT, you can use the older technique described in the "Sort records between a header and trailer " Smart DFSORT Trick at:

Use [URL] BBCode for External Links

sri_mf · Active User Joined: 31 Aug 2006 Posts: 218 Location: India

Thank you Frank...I do not have z/OS DFSORT V1R5 PTF UK90013 so i have opted the second choice

Frank Yaeger · Posted: Thu Aug 07, 2008 10:10 pm