DFSORT help in Variable Block File with diff rec types



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

DFSORT help in Variable Block File with diff rec types

Postby vickypunjabi4 » Wed Jan 08, 2014 9:57 am

Hi

I have a file structure like this

M1C1ARECP
M1C1B______
M1C1C______
M1C1EXXXXX
M1C1ACORR
M1C1B______
M1C1C______
M1C1EXXXXX
M1C1P______
M1C1P______
M1C1ARVRS
M1C1B______
M1C1C______
M1C1EXXXXX
M1C1P______


the 5th byte here i.e. A,B,C E,P here indicate record types.
I want to sort this file based on 6th position to 4 bytes for A type record only, but I want record types to be in same order i.e. A should be first. The file can contain some vales in same position for other record types.
Op should be like this:
M1C1ACORR
M1C1B______
M1C1C______
M1C1EXXXXX
M1C1ARECP
M1C1B______
M1C1C______
M1C1EXXXXX
M1C1P______
M1C1P______
M1C1ARVRS
M1C1B______
M1C1C______
M1C1EXXXXX
M1C1P______

the issue I am facing is that I want A to P records in ascending order based on field of A type record only.

I have a bsic knowledge of Sort not very high level.

I cam eto know that by using these "IFTHEN=(WHEN=GROUP with PUSH" I can solve my issue. Any idea on how can we use this commands in Sort.
Or any other way as well can be really helpful

Please help me
Thanks and Regards
Vicky Punjabi
vickypunjabi4
 
Posts: 3
Joined: Wed Jan 08, 2014 9:52 am
Has thanked: 0 time
Been thanked: 0 time

Re: DFSORT help in Variable Block File with diff rec types

Postby NicC » Wed Jan 08, 2014 2:31 pm

Vicky - posting across different forums is bad manners. Your query is being dealt with elsewhere. I am locking this.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post