Merge fileds Error: Out of sequence in sortin02

arunkumarmuthusamy · New User Joined: 08 Jul 2005 Posts: 1

im trying to merge three ps files

when i submit the job i get an error as

out of sequence in sortin02 or

out of sequence in sortin03

i tried to make the contents of the files in the ascending order

even then im getting the same error.

im also not sure about the sysntax of the merge fields

suggest me a merge field with parameters

here's the job

somasundaran_k · Active User Joined: 03 Jun 2003 Posts: 134

If the input files are not sorted you may get this error. MERGE expects the files to be in the presorted order. Try to sort these files before merging them.

hth
-Som

superk · Posted: Fri Jul 08, 2005 7:42 pm

I don't understand your MERGE statement:

MERGE FIELDS=(12,3,A,6,5,A),FORMAT=CH

The data you show appears to be characters, starting in column 1 for a length of 10. Why is your MERGE statement not defined as:

MERGE FIELDS=(1,10,A),FORMAT=CH

which would give you this output:

aganeshram
arun
bdinesh
cindia
dnarmatha
esanu
fkutti
gmathan
pradeep
push

bagieswari · New User Joined: 03 Apr 2004 Posts: 1

This is the general syntax of the MERGE field.

MERGE FIELDS=(Positionofthefield, Lengthfromtheposition, Ascending/Descending,FORMAT)
Supposing if u want to merge files first on one field, later on another field u'll repeat the same.

And ur merge field says,
U r going to merge the files based
on the field which start at 12th pos, and length 3 and in ascending order.
Then on the field at 6th position and length five.
But in the inputs u have given there is nothing starting at 12th pos
MERGE FIELDS=(12,3,A,6,5,A),FORMAT=CH

Try this

MERGE FIELDS=(1,2,A,CH)

shobam · New User Joined: 18 Jul 2005 Posts: 34 Location: CN

Try Sorting each input file with the following option