Dynamic sort where the keys are not on the same positition

cima · New User Joined: 22 Mar 2006 Posts: 8

Hi all,

I'd like to know if its possible to sort a file, where the keys are not always on the same position.

example:

Input:
ID001.................ID002................ID003..10....................
ID001.................ID003..07..............ID004......................
ID001.................ID003..02..............ID004......................
ID001.................ID002................ID003..01....................

Output:
ID001.................ID002................ID003..01....................
ID001.................ID003..02..............ID004......................
ID001.................ID003..07..............ID004......................
ID001.................ID002................ID003..10....................

Problem: In ID003, there is a subkey (two-digit) which I'd like to sort. However, ID003's position is variable because not all IDs are always present, like the 2nd record, where ID002 is omitted.

Is sorting in this case possible?

Thanks,
cima

Skolusu · Posted: Tue Jun 15, 2010 9:46 pm

cima,

Assuming your input is FB recfm and LRECL of 80 , use the following DFSORT JCL which will give you the desired results

cima · New User Joined: 22 Mar 2006 Posts: 8

Hi Skolusu,

Thanks for the reply..

Actually its VB and LRECL 29998.. Also the 2 DOTS between ID003 and the 2digit Subkey are just fillers.. They have values like:

ID003AB02abcdefg1234ID004
ID003CD07asdfjkl12341ID004

The bluemarked text can have different values..

Sorry for the incomplete infos..

Thanks,
cima

Skolusu · Posted: Tue Jun 22, 2010 3:29 am