Sort Six files mearge to one based on one SEQ ID

raki_new · New User Joined: 10 Feb 2009 Posts: 26 Location: chennai

I want to Sort Six files based on a id present in all files

1,1001,file1,
2,1001,file2,
3,1001,file3,
4,1001,file4,
5,1001,file5,
6,1001,file6,

we need to mearge and put it in sorted order

the problem is its not coming in sorted order

gcicchet · Posted: Fri Feb 13, 2009 3:26 pm

Hi,

you must be doing something wrong.

Gerry

raki_new · New User Joined: 10 Feb 2009 Posts: 26 Location: chennai

My sort card is:
SORT FIELDS=(60,15,CH,A,
01,02,CH,A)
OUTREC FIELDS=(5,224),CONVERT
END

Instead of this way
1,1001,file1,
2,1001,file2,
3,1001,file3,
4,1001,file4,
5,1001,file5,
6,1001,file6,

it gets sorted in this way

5,1001,file5,
2,1001,file2,
1,1001,file1,
3,1001,file3,
6,1001,file6,
.. Randomly
But 1001,1002,1003. .. are in order

Hope u get my point

gcicchet · Posted: Fri Feb 13, 2009 3:32 pm

Hi,

you are sorting and not merging, is the file FB or VB ?

Gerry

raki_new · New User Joined: 10 Feb 2009 Posts: 26 Location: chennai

The file Is VB..
THe ouput is after merging

enrico-sorichetti · Posted: Fri Feb 13, 2009 3:39 pm

You are not showing anything useful

You talk about one field, but the sort card quotes 2
the data does not match the sort card
and ... ... ...

show the exact layout and content of the fields
and maybe You might get some help

gcicchet · Posted: Fri Feb 13, 2009 3:44 pm

Hi,

If your records are VB, then they have a 4-byte RDW followed by the data, you have not allowed for this. 01,02,CH,A is definitely incorrect

Gerry

raki_new · New User Joined: 10 Feb 2009 Posts: 26 Location: chennai

raki_new · New User Joined: 10 Feb 2009 Posts: 26 Location: chennai

The file i gave is just a example

enrico-sorichetti · Posted: Fri Feb 13, 2009 4:10 pm

until You post more descriptive data we cannot do anything,
the jcl does not add any useful info

Frank Yaeger · Posted: Fri Feb 13, 2009 9:33 pm

raki_new,

As Gerry said, since your records are VB, you need to account for the RDW in positions 1-4. The first data byte starts in position 5, not in position 1. Try this: