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
//U117557$ JOB MSGCLASS=X,MSGLEVEL=(1,1),CLASS=B,
//STEP1 EXEC PGM=SORT
//SYSPRINT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SORTIN01 DD DSN=U117557.TRAIN.IN1,DISP=SHR
//SORTIN02 DD DSN=U117557.TRAIN.IN2,DISP=SHR
//SORTIN03 DD DSN=U117557.TRAIN.IN3,DISP=SHR
//SORTOUT DD DSN=U117557.TRAIN.OUT1,DISP=SHR
//SYSIN DD *
im getting a maxcc=16
the contents of the ps files are as follows
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.
superk Moderator Team Head Joined: 26 Apr 2004 Posts: 4650 Location: Raleigh, NC, USA
I don't understand your MERGE statement:
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:
which would give you this output:
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
shobam New User Joined: 18 Jul 2005 Posts: 34 Location: CN
Try Sorting each input file with the following option
and merge the sorted files with
Hope this will work.
All times are GMT + 6 Hours