mainframegurukul.com

Hi,

I have a file having length 80.

The file contains records with several record types i.e. 1,2,---8( One byte field only)

Sample Layout

1000 1 abcd -----
1000 2 hjaskdjk ----
2000 3 dfjkdjf dfgfg
2000 5 abcd -----
1000 5 hjaskdjk ----
2000 6 dfjkdjf dfgfg
1000 6 dfjkdjf dfgfg


I want above file to be sorted only for record type 5 for first 4 bytes , rest of the data should be same as input.

Sample output :

1000 1 abcd -----
1000 2 hjaskdjk ----
2000 3 dfjkdjf dfgfg
1000 5 abcd -----
2000 5 hjaskdjk ----
2000 6 dfjkdjf dfgfg
1000 6 dfjkdjf dfgfg

Regards,
Amol

Is the data already in the order of the second field? Can you have multiple records for other record types? Going by the data supplied a simple sort on major key of record type and minor key of the first four bytes should be sufficient. If not, why not?

Suggest you repost your examples or clarify how the output came to be . . .

It would help if you defined the fields and used beter values than alphabet soup . . .

Use OPTION EQUALS
In INREC, use IFTHEN=(WHEN=(logical expression to identify your type 5s, and OVERLAY=(81:1,4).

SORT on your record-type, followed by the extended field.

Use OUTREC BUILD=(1,80) to return to your original size.

Hi,

I have a file having length 80.

The file contains records with several record types i.e. 1,2,---8( One byte field only)

input

1000 1 Amol
1000 2 Amit
2000 3 Sumit
2000 5 Supriya
1000 5 Rakesh
2000 6 Sarita
1000 6 satish


I want above file to be sorted only for record type 5 for first 4 bytes , rest of the data should be same as input.

Sample output :

1000 1 Amol
1000 2 Amit
2000 3 Sumit
1000 5 Rakesh -- order changed
2000 5 Supriya -- Order changed
2000 6 Sarita
1000 6 satish


There are multiple records for each record type but is it not neccessary to have amount field should be sorted in input file ( Position 1 to 4) , i want to sort on this amount field only for record type 5, rest of the record should be same as sorted on record type.

Regards,
Amol

Did you try what I suggested?

no need to repost your original query - it just 'hides' the additional text.

but is it not neccessary to ...

does this mean that the others must not sorted on bytes 1-4 or does it mean that they can be and no harm is done?

Yes Nicc, i dont want to sort other record ( other than record type 5) on bytes 1-4.

Regards,
Amol

Hi William,

I am trying same, by increasing the record lenth for record type 5 and sorting on extended data and as per requirement , it should work. Thank you !